05-11-2012 06:52 AM - edited 03-16-2019 11:06 AM
All,
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.
Thanks,
Rob
Solved! Go to Solution.
05-11-2012 10:41 AM
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.
05-11-2012 07:08 AM
No, that information is not stored in any table in the DB.
HTH
java
if this helps, please rate
www.cisco.com/go/pdihelpdesk
05-11-2012 08:09 AM
This information is only available via the RIS API set. It's not stored in the SQL database.
GTG
05-11-2012 10:41 AM
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.
03-13-2013 03:13 AM
Hi,
is it possible to get with this report "show risdb query phone
" also these informations?
- directory number
- partition
- pickup group
BR
Michael
03-13-2013 06:40 AM
No, because that command gets the info only from risdb process, not from any table from CUCM.
HTH
java
if this helps, please rate
www.cisco.com/go/pdihelpdesk
03-13-2013 06:43 AM
OK thanks.
Is there any other SQL command to use to get these informations:
- all directory numbers
- partition
- description
- Associated Devices (phone or device profile)
- Call Pickup Group
BR
Michael
03-26-2018 06:05 AM
Hi!
Can apply a filter to the command “show risdb query phone”, that only shows me the unregistered phones?
Which command should I use?
Thanks !!
03-26-2018 06:54 AM
03-26-2018 07:55 AM
03-26-2018 07:40 PM
03-26-2018 08:30 PM - edited 03-26-2018 08:33 PM
The doc talks about the same info which Mohammed had already provided, but it's still a good read.
https://www.cisco.com/c/en/us/support/docs/unified-communications/unified-communications-manager-callmanager/118307-probsol-cucm-00.pdf
Please rate if you find this helpful.
Regards,
Aeby
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: