CUCM sql DN and dependencies

[Bekzod Fakhriddinov]

Hi guys. 

1. Are Dependency records under DN shows same thing as this CUCM sql line: 

 " run sql select d.name,d.description,n.dnorpattern as DN from device as d inner join devicenumplanmap as dmap on dmap.fkdevice=d.pkid inner join numplan as n on dmap.fknumplan=n.pkid where n.dnorpattern='xxxx' order by d.name" 

I am  not sure is it  giving me what i need to find by looking for dependency records?? 

2. Also is it same as associated devices under DN ? 

Thank you 

[Adam Pawlowski]

Yes that in my experience is the same as the associated devices under the DN.

I’m not sure what you’re asking about the dependency records. What do you want to know?

You probably have to come in from another angle depending on what you want to know if it’s related to another function ( partition , vm profile , etc )

[Bekzod Fakhriddinov]

I have whole bunch of recording profiles with bunch of the numbers, and need to check each of them, devices who has these  numbers assigned .