cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
Community

Collab

Useful SQL Queries in CUCM

1151
Views
45
Helpful
0
Comments

To find all translation patterns with Route Next Hop By Calling Party Number enabled and the associated CSS, Partition, description, called and calling transformation masks

 

run sql select n.dnorpattern translation, n.description, c.name as css, pt.name as partition, n.calledpartytransformationmask as xformedMask, n.callingpartytransformationmask as xformingMask  from numplan as n inner join callingsearchspace as c on n.fkcallingsearchspace_translation=c.pkid inner join routepartition as pt on n.fkroutepartition=pt.pkid where (n.routenexthopbycgpn!='f')

 

To find all translation patterns with Route Next Hop By Calling Party Number disabled and the associated CSS, Partition, description, called and calling transformation masks

 

run sql select n.dnorpattern translation, n.description, c.name as css, pt.name as partition, n.calledpartytransformationmask as xformedMask, n.callingpartytransformationmask as xformingMask  from numplan as n inner join callingsearchspace as c on n.fkcallingsearchspace_translation=c.pkid inner join routepartition as pt on n.fkroutepartition=pt.pkid where (n.routenexthopbycgpn='f')

 

To find all patterns with Urgent Priority (Translation Patterns or Route Patterns) enabled and the associated CSS, Partition, description, called and calling transformation masks

 

run sql select n.dnorpattern translation, n.description, c.name as css, pt.name as partition, n.calledpartytransformationmask as xformedMask, n.callingpartytransformationmask as xformingMask  from numplan as n inner join callingsearchspace as c on n.fkcallingsearchspace_translation=c.pkid inner join routepartition as pt on n.fkroutepartition=pt.pkid where (n.patternurgency!='f')

 

To find all patterns with Urgent Priority (Translation Patterns or Route Patterns) disabled and the associated CSS, Partition, description, called and calling transformation masks

 

run sql select n.dnorpattern translation, n.description, c.name as css, pt.name as partition, n.calledpartytransformationmask as xformedMask, n.callingpartytransformationmask as xformingMask  from numplan as n inner join callingsearchspace as c on n.fkcallingsearchspace_translation=c.pkid inner join routepartition as pt on n.fkroutepartition=pt.pkid where (n.patternurgency='f')

 

 

To find all patterns with Provide Outside Dial Tone enabled and the associated CSS, Partition, description, called and calling transformation masks

 

run sql select n.dnorpattern translation, n.description, c.name as css, pt.name as partition, n.calledpartytransformationmask as xformedMask, n.callingpartytransformationmask as xformingMask  from numplan as n inner join callingsearchspace as c on n.fkcallingsearchspace_translation=c.pkid inner join routepartition as pt on n.fkroutepartition=pt.pkid where (n.outsidedialtone!='f')

 

To find all patterns with Provide Outside Dial Tone disabled and the associated CSS, Partition, description, called and calling transformation masks

 

run sql select n.dnorpattern translation, n.description, c.name as css, pt.name as partition, n.calledpartytransformationmask as xformedMask, n.callingpartytransformationmask as xformingMask  from numplan as n inner join callingsearchspace as c on n.fkcallingsearchspace_translation=c.pkid inner join routepartition as pt on n.fkroutepartition=pt.pkid where (n.outsidedialtone ='f')

 

To find all patterns with Use Originator’s Calling Search Space enabled and the associated CSS, Partition, description, called and calling transformation masks

 

run sql select n.dnorpattern translation, n.description, c.name as css, pt.name as partition, n.calledpartytransformationmask as xformedMask, n.callingpartytransformationmask as xformingMask  from numplan as n inner join callingsearchspace as c on n.fkcallingsearchspace_translation=c.pkid inner join routepartition as pt on n.fkroutepartition=pt.pkid where (n.useoriginatorcss!='f')

 

To find all patterns with Use Originator’s Calling Search Space  disabled and the associated CSS, Partition, description, called and calling transformation masks

 

run sql select n.dnorpattern translation, n.description, c.name as css, pt.name as partition, n.calledpartytransformationmask as xformedMask, n.callingpartytransformationmask as xformingMask  from numplan as n inner join callingsearchspace as c on n.fkcallingsearchspace_translation=c.pkid inner join routepartition as pt on n.fkroutepartition=pt.pkid where (n.useoriginatorcss ='f')

 

CreatePlease to create content