cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
367
Views
0
Helpful
2
Replies

CUCM 12.5 User Device Profile SQL Query

Joel Jones
Level 1
Level 1

Hello, does anyone have a SQL query that will export all User Device Profiles in a way that mirrors the BAT tool? The BAT tool, while nice, does not help automate anything. I'm looking for something that mirrors Export User Device Profiles - All Details.

Thanks!

2 Replies 2

If you are looking for an output same as bulk export it would be hard…

but if it’s just few  details we can have a sql query 



Response Signature


Joel Jones
Level 1
Level 1

The BAT export tool for getting that data out is so cumbersome and not really fast... The goal is having a higher level view on standardizing things and making sure we have everything in line. I guess as a start, we could only query against the UDP's themselves and not worry about the DN's that are associated to the UDP's.

UDP Information:

  • Device Profile Name
  • Description
  • Phone Button Template
  • User Hold MOH Audio Source
  • Device User Locale
  • Softkey Template
  • MLPP Preemption
  • Device Type
  • User ID 1
  • User ID 2
  • DND Option