Are the individual phone registration status stored anywhere in the CUCM DB that can be queried via SQL? If so, can someone share which table and value?
I know there are multiple alternate ways of getting this information, but I am working on some custom SQL queries for CUCM that I would like to add device registration status to.
Go to Solution.
Depending on how you are accessing the SQL query (CLI, AXL, Other) you could run the following command on the CLI (per server):
show risdb query phone
Anthony Holloway Please use the star ratings to help drive great content to the top of searches.
No, that information is not stored in any table in the DB.
HTH java if this helps, please rate www.cisco.com/go/pdihelpdesk
This information is only available via the RIS API set. It's not stored in the SQL database.
is it possible to get with this report "show risdb query phone" also these informations?
- directory number
- pickup group
No, because that command gets the info only from risdb process, not from any table from CUCM.
Is there any other SQL command to use to get these informations:
- all directory numbers
- Associated Devices (phone or device profile)
- Call Pickup Group