Devices reports or phone reports are basically a list of CUCM devices from which you can get some information, like Device name, software version, IP address, MAC address, protocol and some other.
What is it helpful for?
This is helpful if you need to know how many devices you have on your CUCM cluster, or if you need to know what are the MAC addresses, or what version of software those devices are using, this will help you to manage and keep track of your devices.
Isn't this provided by the Unified Reporting on CUCM already?
Some of this information can be gathered using the available reports, or using SQL queries, but not all of it.
List of all registered and unregistered devices
This will get a list of all devices, name, model, FW version, registered or unregistered devices.
(Note: devices that have never registered before will not show up on this list)
Step 1. Login to CUCM's CLI Step 2. Start logging / capturing ALL the output on your SSH terminal Step 3. Enter the show risdb query phone command Step 4. Once the command has finished, stop the session output login Step 5. Open the session output file on a text editor that supports UNIX end of line (like notepad++) Step 6. Save the file as a .csv file Step 7. Open the csv file on excel (or another spreadsheet program, following instructions are based on Excel) Step 8. Remove the first section (#TotalPhones, #TotalRegistered,....) Step 9. Resize the columns for better view
You may also filter this report to get info about a particular phone model, or FirmWare version, IP address range etc, see below for details on that.
- Select the first row, then select the 'Data' menu, then click on 'Filter' (see screen shots below)
- Click the drop-down icon on the column that you would like to filter by, for example DeviceName column there you and select 'Text Filters' then select 'Begins with' there you can type your search criteria (for example CSF if you want to view only Jabber devices)
- If you want to filter by FirmWare version click the drop-down icon on the ActiveLoadId column, then select the one you want to use as filter, you may do the same on the IP column
Notice: If you want to know which CUCM server the device is registered on, look at column " DnldServer"
DeviceModel is code-based, you can get the list of device models from the "CUCM system error messages" doc