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')