cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

7695
Views
30
Helpful
11
Replies

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
VIP Advisor

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.
11 REPLIES 11
Hall of Fame 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
Collaborator

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.
VIP Advisor

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.
Beginner

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

Hall of Fame 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
Beginner

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

Beginner

Re: CUCM SQL - Phone Registeration Status

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 !!

VIP Advisor

Re: CUCM SQL - Phone Registeration Status

You can view this nicely from RTMT and filter as needed. Go to Voice/Video
> Device > Device Search > Go to Device Search > Phone
Highlighted
Beginner

Re: CUCM SQL - Phone Registeration Status

Thanks for the info!
The problem that I've is that with the RTMT I can´t export this information to an Excel or Acces.
Is there any tool to do this?
Thnaks!

Paul/Pablo
VIP Advisor

Re: CUCM SQL - Phone Registeration Status

In this case export the entire table from risdb command and use excel
filter to get the data you want (filter based on status)
Participant

Re: CUCM SQL - Phone Registeration Status

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



Please rate if you find this helpful.

Regards,
Aeby
CreatePlease to create content
Content for Community-Ad
August's Community Spotlight Awards