04-13-2019 06:10 AM
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
Solved! Go to Solution.
05-10-2019 07:46 AM
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
04-13-2019 11:28 PM
Hi ,
Why do you need sql? Why don't you try BAT to generate report.
You may find your answer in following thread.
Regards
Shalid (please rate post if you find useful)
04-14-2019 10:41 PM - edited 04-14-2019 10:42 PM
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.
04-14-2019 02:40 AM
05-10-2019 07:46 AM
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
05-13-2019 07:37 AM
Working :) . Thank you so much.
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