03-02-2017 07:07 PM - edited 03-19-2019 12:11 PM
Hi all,
I am just learning about SQL queries and their power. Can you please tell me of a query that will allow me to search pattern 39987 and its partition? Also, would you be so kind as to breaking down the query for me so that I know what each part of it is doing? Thanks.
Solved! Go to Solution.
04-21-2017 06:26 PM
Glad you found what you were looking for. However, for everyone else's sake, you can find this info with these queries.
First, you will need to find that DN in the
run sql select dnorpattern,description,fkroutepartition from numplan where dnorpattern='39987'
So
run sql select name,description from routepartition where pkid='INSERT fkrouteparition GUID'
Hope this helps.
03-02-2017 11:10 PM
If you want to learn about queries your primary reference is going to be the DB dictionary to understand how the CUCM DB looks like, have you looked at it?
03-06-2017 07:48 AM
Thanks Jaime, I did look at it. It seems a little difficult to understand specially because all tables are in a single page.
04-19-2017 01:56 PM
Adan,
Is 39987 a DN or something else?
Thanks
Tim
04-21-2017 05:05 PM
Hi Tim,
Yes, this is a DN, I actually figured this one out. Thanks for the reply!
04-21-2017 06:26 PM
Glad you found what you were looking for. However, for everyone else's sake, you can find this info with these queries.
First, you will need to find that DN in the
run sql select dnorpattern,description,fkroutepartition from numplan where dnorpattern='39987'
So
run sql select name,description from routepartition where pkid='INSERT fkrouteparition GUID'
Hope this helps.
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