CUCM SQL - Phone Registeration Status

[robertphillips2]

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

[Jaime Valencia]

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

HTH

java

if this helps, please rate

www.cisco.com/go/pdihelpdesk

[Gordon Ross]

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

GTG

[Anthony Holloway · Accepted 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.

[mischm]

Hi,

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

- directory number

- partition

- pickup group

BR

Michael

[Jaime Valencia]

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

[mischm]

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

[pabareiro]

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

[Mohammed al Baqari]

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

[pabareiro]

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

[Mohammed al Baqari]

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

[Aeby Vinod]

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