Dear fellow UC colleagues,
I need to export to a file, CSV or any, a snapshot of endpoints of a certain type (phones,analog ports, but excluding: softphones) registered to any UCM node in my cluster, but based on:
1. primarily IP subnet range
2. ideally, also another export but based on roaming device pool
3. (based on device pool)
I can have a snapshot based on IP subnet range using RTMT - but then I cannot copy paste that output into a XLS file, which is all that I miss unfortunately. Or do I overlook something in RTMT which allows for this export?
So I am thinking it needs to be done using SQL - but does anyone have the knowledge on how to contruct these SQL queries?
any help is much appreciated!
kind regards, Juan
There is no SQL query for it AFAIK as this info is in memory. One way I handle is as following:
In addition to what Chris already mentioned, the registered device information is not maintained in the CCM DB and thus no sql query can be utilized.
It is maintained by the RIS service in CUCM.
You can run the following command on the CUCM CLI to get a dump of all the information of the registered phones on that particular node as follows:
++ Show risdb query phones
You can copy and paste the output in a csv file in Excel and then apply filters according to your requirement.
Rate and mark correct if helpful.
thank you for the answers - I appreciate it.
I understand it comes from the RIS DB and it gets me started.
However, I was hoping for something more - for example a way in RTMT to enable an export of the device search - as that more or less ties together the needed information - or some already constructed SQL statements that tie things together