10-26-2014 09:29 PM - edited 03-19-2019 08:47 AM
Hi guys,
I have a customer who would like to find out which User Device Profiles are not being used. I think the following methods would work but I have no idea how to do these in bulk:
1: Figure out if the User Device Profile is associated with a user or not
2: Figure out when the last time the user device profile was used (Is this possible? Direct database query? If so how?)
Any help would be greatly appreciated
-Akin
10-27-2014 12:37 AM
I had the same issue in my former company but luckily we used the "Login User ID" field wher we had the end user associated.
As soon as the User left the company and therefor was deleted in CUCM that field became empty.
So what I did was following
Generate a User Device Profile Report (Bulk Administration > User device Profiles > Generate UDP Reports
Select from the device fields Profilename and Login User ID
Let the report run and open the report file (you will find it at the job scheduler)
All UDP's without a login user ID are usually not assigned to a user and you may want to delete those.
No idea about the SQL query but you maybe find something usefull in the database dictionary http://www.cisco.com/c/en/us/support/unified-communications/unified-communications-manager-callmanager/products-programming-reference-guides-list.html
Eike
11-30-2015 08:54 PM
Awesome, that's the route I went down. Thanks for the helpful reply!
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