02-28-2017 11:41 PM - edited 03-17-2019 09:40 AM
Hello,
I have seen the following document which describes how to generate a report for phones using BAT.
http://www.cisco.com/c/en/us/support/docs/voice-unified-communications/unified-communications-manager-version-70/113496-phone-report-00.html
Is there anyone in the community could tell me how to generate a report which shows all of the phones which are presently "status = Registered" and user ID which is associated to the device?
Thanks in advance.
Darin
Solved! Go to Solution.
03-01-2017 06:03 AM
Here is a quick way to get it:
03-01-2017 02:26 AM
Hi Darin,
You could use the below command in CLI and export the information in CSV to get all details regarding the phones.
show risdb query phone
HTH
Rajan
Pls rate all useful posts
03-01-2017 03:19 AM
As Rajan mentioned, you can use show risdb query phone to get the list of all phones on that particular node.
In order to get the list of user ids associated to the devices find the below link for the sql query.
http://www.cisco.com/c/en/us/support/docs/unified-communications/unified-communications-manager-callmanager/117726-technote-cucm-00.html#anc9
You can not get both outputs in a single command.
Hope this helps.
Regards
Abhay
03-01-2017 06:03 AM
Here is a quick way to get it:
01-23-2023 05:12 AM
didn't work since CUCM 14.x ==> fallback to 250 rows per page
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