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
