topic Re: Unregistered Phone Report in Unified Communications Infrastructure

Unregistered Phone Report

Hariharan Padmanabhan — Tue, 19 Mar 2019 09:41:11 GMT

Dear All,

Can someone help me here?

is there anyway to generate the unregistered phone details from cucm?

If we have, please share the steps.

Re: Unregistered Phone Report

William Bell — Tue, 05 Apr 2011 16:13:13 GMT

RTMT may be able to help you out. Launch RTMT.

Then go to CallManager>Devices>Device Search>Open Device Search>Phone (see below)

Then select "Unregistered", choose your CallManager (or "Any") then choose Next or Finish.

If you choose Next you can further fine tune what gets displayed.

Note that this report focuses on "Unregistered" devices. This means that the device was once registered. If a phone never registered, then it will not show up in this report.

HTH.

Regards,

Bill

Please rate helpful posts.

Re: Unregistered Phone Report

Hariharan Padmanabhan — Tue, 05 Apr 2011 17:02:02 GMT

Dear William,

Thanks for your information.

I have one more question. I am able to generate the registered phone list without any issue, but unable to do unregistered phone. Do i need to enable something?

Please help me here.

Re: Unregistered Phone Report

William Bell — Tue, 05 Apr 2011 18:15:31 GMT

There is no special parameter that I am aware of which would enable/disable the ability to report on unregistered phones. Are you getting an error message or just an empty table? If you were expecting more devices to be listed then you may be running into a common problem. A device is only reported as unregistered if it, at one time, held a status of registered. This could mean a few things. The most common reason is that a device was configured but never seen on the network. The second most common is that a device that was once unregistered, never re-registered, and the record status has timed out or the phone was reset (from CCMAdmin, BAT, etc.).

To test, you can take a registered phone and disconnect it from the network. Give RIS a minute or so to propagate the data and then run the unregistered query again.

Now, this won't solve the problem if you really just want to see all devices that are not registered (whether they be "unregistered", etc.). From RTMT you can query on devices that are only configured in the database. You may also need to query on rejected or partially registered status as well. Personally, I use a tool I developed to get this information so I may be out of touch with recent updates to RTMT capabilities.

HTH.

Regards,
Bill

Re: Unregistered Phone Report

pabareiro — Mon, 26 Mar 2018 13:08:56 GMT

Hi!

I'm using the command “show risdb query phone” in order to export the information.

Do you know how can I filter the unregistered phones whit this command?

Thanks a lot!

Re: Unregistered Phone Report

kfilippo — Fri, 27 Apr 2018 14:04:22 GMT

Bill:

Do you know how long the record status time-out is?

The second most common is that a device that was once unregistered, never re-registered, and the record status has timed out or the phone was reset (from CCMAdmin, BAT, etc.).

Re: Unregistered Phone Report

andrewboyce — Mon, 25 Jun 2018 17:56:07 GMT

Any way to export this to CSV, etc.?

Re: Unregistered Phone Report

Ratheesh Kumar — Mon, 25 Jun 2018 18:16:07 GMT

Unfortunately there is no native way of achieving this. You can do like this. Device > Phone > Find all phones (You can better select with the required models here, otherwise all your CTI ports/Analog ports will pop up)
Find all the phones and copy the content and paste it to a Excel file. Then you can filter with the Unregistered status
A bit of workaround with excel files, but still works !!

Hope this Helps
Cheers
Rath!

***Please rate helpful posts***

Re: Unregistered Phone Report

jinish.valath — Thu, 28 Jun 2018 01:20:34 GMT

How are you copying this from RTMT to paste onto Excel? I cant seem to do so.

Re: Unregistered Phone Report

Ratheesh Kumar — Thu, 28 Jun 2018 01:58:45 GMT

No option of copying from RTMT. I meant navigate to Device > Phone and Find all phones. You can basically copy the details and paste it to an excel file. Then you can Filter with the status

Hope this helps

Cheers

Rath!

***Please rate helpful posts***

Re: Unregistered Phone Report

jinish.valath — Thu, 28 Jun 2018 04:10:45 GMT

Hi Rath,
What I meant is, how did you copy the details and paste into excel? Ctrl a, or Ctrl c does not seem to work.
Regards

Re: Unregistered Phone Report

Ratheesh Kumar — Thu, 28 Jun 2018 14:22:19 GMT

Yes. Just copied the content using your mouse copy and paste it to a Excel file.

Hope this helps!

Cheers
Rath!

***Please rate helpful posts***

Re: Unregistered Phone Report

MichaelWells5 — Fri, 28 Feb 2020 20:56:25 GMT

Just wanted to follow up ...

To past into Excel, use the Paste Special option - either by clicking on Paste Icon > Paste Special, or hitting Ctrl+Alt+V. Then select Unicode text.

Would be nice if Cisco could unify phone reporting between BAT, RTMT and CLI -- and add export as pdf or excel file from RTMT!

Re: Unregistered Phone Report

DS3203 — Tue, 12 May 2020 09:46:15 GMT

use the tool in the website given below to pull the registration report:

https://www.networkclan.com/tools/voicetools/

Re: Unregistered Phone Report

C J Hsu — Fri, 13 Jan 2023 08:37:17 GMT

Hello, mind to share the SQL query for unregistered phone with this VoiceTools.

Re: Unregistered Phone Report

Daniel Bosch — Fri, 13 Jan 2023 19:22:51 GMT

Painful. If this is something you need to do on the regular, you might beg for a 3rd party platform like Variphy that can generate a phone registration report for you in a few minutes. And, yes, it includes configured phones in "Unknown/Never" Reg state.