filter only unregistered phones

[JustTakeTheFirstStep]

I have two questions.

Can I filter only those phones that are marked as unregistered? I want to see only unregistered phones in the phone list.

And I want to know the time when the phone changed to unregistered.

Is there a way??

[Roger Kallberg]

It depends on your version of CM. With 12.5 and likely also 12.1 you have information about registration status. In that webUI you can search by Last Registered and Last Active.

[JustTakeTheFirstStep]

CUCM is version 8.6.2

[Roger Kallberg]

Then unfortunately no.

[Maren Mahoney · Accepted solution]

You could use RTMT to do a Device Search for phones in unregistered status, but that list is view only and not exportable. There may be a way to do a SQL search via the command line, but I don't know how to do that myself.

Maren

[JustTakeTheFirstStep]

Can you provide a guide for each staff??

RTMT is installed.

[Jaime Valencia]

Nope, no way via SQL (at least not on his version), that info was not stored anywhere until 12.5 where you see the last active and last registered status.

[JustTakeTheFirstStep · Accepted solution]

Data Export)

Data is captured after tracking status in RTMT.
Afterwards, extracting the text from the screenshot is simple.

https://www.newocr.com/