CUCM Device Registration Search

[Jason Amick]

Was curious to know if it is possible to search using CCMadmin to search and see what devices are registered to which subscribers?  I have not found an easy search/filter in call managers UI to find what I am looking for.  All devices should be registered to the primary sub unless there is an outage then all devices should fail over to the secondary sub.  I have looked in RTMT using "device search" and think I can get the information needed that way but thought there has to be a way I can achieve this from the web interface of CUCM.  Thanks for any help!!

Setup Consists of:

CUCM version: System version: 8.6.2.23900-10

- 1 Publisher

- 3 Subscribers

[Ayodeji Okanlawon · Accepted solution]

You can use the following command

• show risdb query phoneextn phone

This needs to be run on each cucm server. It will display the phones registered to that server and there ip addresses. You can export the result to excel and sort values out.

[Jason Amick]

Ayodeji:

Thanks for the information, is that command no CPU intensive and could be run during business hours?  Thanks again!!

[Ayodeji Okanlawon]

No it is not. It is very quick too and yes you can run during business hours..

[Jason Amick]

Ayodeji:

Using this command on our secondary subscriber shows a count of 799 devices but after searching for several devices included in this query I find them registered to the primary sub.

[Ayodeji Okanlawon]

The query list all the columns in risdb phone table. I

I am shocked to hear that the devices are registered else where as this will only show devices registered to the server. This is a real time information and as such cant be devices registered else where. I just tested this on my cluster now and it works as expected.

show risdb query phone
----------- Phone Information -----------

#TotalPhones, #TotalRegistered, #RegisteredSCCP, #RegisteredSIP, #UnRegistered, #Rejected, #PartiallyRegistered, StateId, #ExpUnreg
1137, 1123, 1120, 3, 12, 2, 0, 46024,0

[Jason Amick]

I agree its odd.  We have 3 subscriber .12, .13, and .14.  When I run this query on the secondary .13 one of the (799) results I received would be:

SEP001BD52C9DB8, Sherri Snovell, 10.1.42.111, , 3, 0, 001BD52C9DB8, unr, SCCP, 30018, yes, 1, 30044, NoUserId, 27292, 1420687739, 1, SCCP41.9-3-1SR1-1S, SCCP41.9-3-1SR1-1S, , , , 0, , 1420687739

When I look that mac address up in CUCM it shows the phone clearly registered to .12 the primary.

[Ayodeji Okanlawon]

its because you are not interpreting the output correctly..This phone is cleary unregistered with this server

SEP001BD52C9DB8, Sherri Snovell, 10.1.42.111, , 3, 0, 001BD52C9DB8, unr

The unr by the phone means unregistered.

This is an example of a registered phone

SEP00137FDD3433, NG-EM, 10.1.8.10, , 0, 0, 00137FDD3433, reg

You can see reg by the mac address of the phone.

It is possible that this phone has registered with this server sometimes in the past but it not registered as at the time you ran the command.

[Carlo Poggiarelli]

Hi Jason.

With field "RegStatusChg TimeStamp" you can also see when the device has changed its status (from reg to unreel and/or viceversa)

Regards

Carlo

[Jason Amick]

Very useful information you guys have provided which I could not get out of a TAC case.  Thanks again.

[Carlo Poggiarelli]

Hi Jason.

Very glad to hear that our answers were useful.

Please remember to rate useful posts and mark as correct the answer that solved your issue 

Regards

Carlo

[Aaron Harrison]

Useful stuff guys (+5); I didn't know about that command though I knew about the base API :-)

[Carlo Poggiarelli]

Hi Jason.

+5 to my buddy Deji for his excellent suggestion ;)

RisDB shows you phones in both registered and unregistered status.

If you see some phones in both primary and secondary subscriber, that means that those phone are in Unregistered status in one server and Registered status in the other server

If you see in the output you can note that there is a RegStatus field which will be reg for registered phones  or unr for unregistered.

I suggest you to export the output of that command and put it in a text file and use it with Excel importing it as a CSV.

HTH

Regards

Carlo

[Jason Amick]

Carlo:

Thanks for your input and you are right the 799 devices showing up when running this command all listings show them as unregistered.  Thank you both for your help I think I have enough information here to get the information I am looking for.

[Ayodeji Okanlawon]

Carlo (great explanation +5)..