Generating a reports for Phones which shows all registered devices to the call manager cluster

[darin.marais]

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

[Rajan]

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

[Abhay Singh Reyal]

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

[Chris Deren · Accepted solution]

Here is a quick way to get it:

1. Select to find all phones under device page
2. When initial 50 records are found, change the search limit "rows per page" to 250 via the drop down menu
3. After that go to the URL, and edit it such that the count of rows per page is greater than your total devices:  https://<CUCM>/ccmadmin/phoneFindList.do?lookup=false&multiple=true&rowsPerPage=10000&pageNumber=1
4. Now, you can copy the results from browser and past as special to Excel and then sort by "IPv4 dress".  

[guenterhof]

didn't work since CUCM 14.x ==> fallback to 250 rows per page