CUCM SQL - Phone Registeration Status

Endorsed Question
May 11th, 2012
User Badges:

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

Cisco Endorsed by jjithin
Anthony Holloway about 5 years 3 months ago

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.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (2 ratings)
Loading.
Gordon Ross Fri, 05/11/2012 - 08:09
User Badges:
  • Blue, 1500 points or more

This information is only available via the RIS API set. It's not stored in the SQL database.


GTG

Anthony Holloway Fri, 05/11/2012 - 10:41
User Badges:
  • Purple, 4500 points or more

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.

Actions

This Discussion