Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Community Member

CUCM SQL - Phone Registeration Status

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

1 ACCEPTED SOLUTION

Accepted Solutions

Re: CUCM SQL - Phone Registeration Status

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.

Anthony Holloway

Please use the star ratings to help drive great content to the top of searches.
6 REPLIES
Cisco Employee

CUCM SQL - Phone Registeration Status

No, that information is not stored in any table in the DB.

HTH

java

if this helps, please rate

www.cisco.com/go/pdihelpdesk

HTH

java

if this helps, please rate

www.cisco.com/go/pdi

CUCM SQL - Phone Registeration Status

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

GTG

Please rate all helpful posts.

Re: CUCM SQL - Phone Registeration Status

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.

Anthony Holloway

Please use the star ratings to help drive great content to the top of searches.
Community Member

CUCM SQL - Phone Registeration Status

Hi,

is it possible to get with this report "show risdb query phone" also these informations?

- directory number

- partition

- pickup group

BR

Michael

Cisco Employee

CUCM SQL - Phone Registeration Status

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

HTH

java

if this helps, please rate

www.cisco.com/go/pdi
Community Member

CUCM SQL - Phone Registeration Status

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

5808
Views
5
Helpful
6
Replies
CreatePlease to create content