cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
497
Views
5
Helpful
6
Replies
Highlighted
Beginner

Find which CSS a given partition is in

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. 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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.

Br, Nadeem Please rate all useful post.

View solution in original post

6 REPLIES 6
Highlighted
Engager

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

Highlighted

Vivek,

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

Highlighted

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.

Br, Nadeem Please rate all useful post.

View solution in original post

Highlighted

Thanks Nadeem 

Highlighted

This was useful.  Thanks.

Highlighted
Hall of Fame Cisco Employee

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.

HTH

java

if this helps, please rate