Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

SQL Query to get the Partition of a particular DN

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. 

Everyone's tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions
New Member

For everyone elses sake I

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 numplan table.

run sql select dnorpattern,description,fkroutepartition from numplan where dnorpattern='39987'

fkroutepartition in the numplan table is a link to the pkid in the routepartition table.
So lets search the routepartition table for that pkid.

run sql select name,description from routepartition where pkid='INSERT fkrouteparition GUID'

Hope this helps. 

5 REPLIES
Cisco Employee

If you want to learn about

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?

HTH

java

if this helps, please rate

www.cisco.com/go/pdi
New Member

Thanks Jaime, I did look at

Thanks Jaime, I did look at it. It seems a little difficult to understand specially because all tables are in a single page. 

New Member

Adan, 

Adan, 

Is 39987 a DN or something else? 

Thanks

Tim

New Member

Hi Tim,

Hi Tim,

Yes, this is a DN, I actually figured this one out. Thanks for the reply!

New Member

For everyone elses sake I

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 numplan table.

run sql select dnorpattern,description,fkroutepartition from numplan where dnorpattern='39987'

fkroutepartition in the numplan table is a link to the pkid in the routepartition table.
So lets search the routepartition table for that pkid.

run sql select name,description from routepartition where pkid='INSERT fkrouteparition GUID'

Hope this helps. 

33
Views
0
Helpful
5
Replies