CUCM SQL Query to get device profile information from CUCM 10.5

[ajey_shetty]

Can anyone help me with CUCM SQL Query to pull following device profile details from CUCM 10.5

Device Profile Name
Description
Extension number associated

Thanks,
Ajey Shetty

[Shalid Kurunnan Chalil]

Hi ,

Why do you need sql? Why don't you try BAT to generate report.

You may find your answer in following thread.

https://community.cisco.com/t5/ip-telephony-and-phones/cucm-10-5-sql-to-find-user-device-profiles-set-as-logged-out/td-p/3372916

Regards

Shalid (please rate post if you find useful)

[ajey_shetty]

I need SQL because I am pulling that data using AXL and I am trying to automate a process to dump the DP data to our BI tool.

I checked the post you shared but did not help me much.

[HARIS_HUSSAIN]

Use BAT To export the PRofile Information.

*** Please rate helpful post; Mark "Accept as a Solution" if applicable

Thanks,
Haris

[a.janssen · Accepted solution]

run sql select d.name as udp, d.description, n.dnorpattern as number from device as d inner join devicenumplanmap as dnpm on dnpm.fkdevice = d.pkid inner join numplan as n on dnpm.fknumplan = n.pkid and d.tkclass = 254

[ajey_shetty]

Working :) . Thank you so much.