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

[fahad ck]

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)

[Carlo Poggiarelli]

Hi

You can use show risdb query phone.

Put the result on a csv file and filter for unreg state.

HTH

Regards

Carlo

[fahad ck]

Thanks a lot Carlo!!

Let me check it out.

[Jitender Bhandari]

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