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