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

New Hall of Fame Member-Peter PAluch

Useful SQL Queries in CUCM

961
Views
40
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
Content for Community-Ad

This widget could not be displayed.
Blog-Cisco Community Designated VIP Class of 2019