06-10-2015 09:10 AM - edited 03-17-2019 03:17 AM
Hi
Could anyone share SQL query that can be used at the command line to find all phones in an unregistered state and the last time it registered to the Call Manager (MCS)
06-10-2015 10:15 AM
Hi
You can use show risdb query phone.
Put the result on a csv file and filter for unreg state.
HTH
Regards
Carlo
06-10-2015 10:44 AM
Thanks a lot Carlo!!
Let me check it out.
06-12-2015 08:56 AM
Hi
Adding to what Carlo posted.
"show risdb query phone" will return the device count for that particulate node where you run it, if you have more then one mode you will have to run it individually on every.
HTH
JB
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide