11-23-2002 05:15 PM - edited 03-12-2019 09:42 PM
I am trying to delete some calling search spaces but I can't find them. When I do a search for phones they do not appear. When I do a search under lines in BAT they are not found. I have checked voice-mail mwi/ports/lead, call-park, call-pickup, meet-me, web attendant, cti ports, translation patterns, and gateways.
Why isn't there a tool to simply see every device, logical or physical, and what CSS, partition, etc. it is using? That doesn't seem so hard...
11-24-2002 06:52 AM
have you tried Route PLan Calling Search Space? You can also search for devices in calling search spaces in Device Phone.
Geoff
11-26-2002 05:06 PM
Well, I know that the CSS's exist. I'm trying to delete them from "Route Plan->Calling Search Space". And I have searched for the calling search space in "Device->Phone". I think these rogue CSS's are on the LINE of the phones, but there seems to be no way to search for that.
I was thinking more along the line of manually searching the SQL database for the LINE CSS... or something else?
03-28-2013 09:28 AM
I know this is old, but hopefully it will help someone. I just had the same issue and I found using this SQL query helped me track down where the calling search space was applied, specifically it checks call forwarding CSSes of lines. Just be careful if you have a large cluster, you should run this afterhours and not on a call processing node if you can avoid it.
run sql select n.dnorpattern, css1.name as primaryCSS, css2.name as secondaryCSS from numplan as n inner join callforwarddynamic as cdn on cdn.fknumplan=n.pkid left join callingsearchspace as css1 on cdn.fkcallingsearchspace_cfa=css1.pkid left join callingsearchspace as css2 on cdn.fkcallingsearchspace_scfa=css2.pkid where n.tkcfacssactivationpolicy = 1 or n.tkcfacssactivationpolicy = 0 order by n.dnorpattern
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide