Find which CSS a given partition is in

[mr_cisco_cisco]

How do you determine which calling search spaces contain a specific partition?

It's not practical to go through them one at a time as there are too many to look through.  I thought about enabling dependency records but it seems this may cause a CPU spike. 

[Vivek Batra]

Currently I don't have access to call manager to verify but I think on CSS page, there is a filter which can be searched for specific partition.

- Vivek

[mr_cisco_cisco]

Vivek,

I just checked and there is no option to filter by partition. 

[Nadeem Ahmed · Accepted solution]

Check this forum this might help what you are looking but not from GUI alteast from CLI.

http://www.ucguerrilla.com/2012/04/cucm-sql-query-series-installment-6.html.

also test in my lab it works like charm

run sql select css.name as css, css.description, csm.sortorder, rp.name as partition, rp.description from callingsearchspace as css inner join callingsearchspacemember as csm on csm.fkcallingsearchspace = css.pkid inner join routepartition as rp on csm.fkroutepartition = rp.pkid order by css.name, csm.sortorder

while running this please take care of space or any syntax.

Br,
nadeem

Please rate all useful post.

[Rajeev Samantha]

Thanks Nadeem 

[mr_cisco_cisco]

This was useful.  Thanks.

[Jaime Valencia]

Besides going to the data dictionary, and creating your custom SQL query to find that out (which is what dependency records does for you), you would need to go into every single CSS to find that.

simply enable dependency records, to find this out.