12-04-2015 10:13 AM - edited 03-19-2019 10:27 AM
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.
Solved! Go to Solution.
12-04-2015 10:58 AM
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.
12-04-2015 10:18 AM
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
12-04-2015 10:31 AM
Vivek,
I just checked and there is no option to filter by partition.
12-04-2015 10:58 AM
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.
12-04-2015 11:06 AM
Thanks Nadeem
12-07-2015 09:23 AM
This was useful. Thanks.
12-04-2015 10:56 AM
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.
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