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

Who Me Too'd this topic

SQL command in CUCM to get list of phones and registration status and Owner ID

CiscoRunner
Beginner
Beginner

I am trying to figure out a way that I can gather a list of all IP phone with the Registration status (Registered, UnRegistered, Unknown). I have tried by using RTMT but that data is not exportable.

I have also tried using "show risdb query phone" but the problem with that was that it only gives you the info for the phones that are currently Registered to the system, so you dont get the info for unregistered phones.

My final attempt to get the data will be a SQL command via the CLI. So far I only know of 

run sql select name,description from device where name like ‘SEP%’

This command does give me data but I am not sure which field is the registration status or the Owner ID

Would anyone have any idea which field refers to the registration status & Owner ID from the output of the SQL command

 

Many thanks in advance

Who Me Too'd this topic