Cucm dB query

[yadwindersingh]

Currently I am working on cucm 6.1 mcs servers. 

I Have an issue that when I run risdb query phone command on publisher  to get my registered/unregistered phone details than I observed that it is showing some phones are registered on subscriber server but those are showing unregistered on publisher server. The registered phone count is OK and matching with rtmt. 

Now my question is that when my phones are registered only on subscriber server then why they are showing on publisher. 

2ndly if showing on publisher is OK, but why showing unregister. 

Here due to this problem

Pub reg + pub unreg + sub reg  +sub unreg >total phones. 

Pub reg +sub register +sub unregister=total phones

I mean to say that pub unregistered phones are duplicate entries of sub.  Registered or unregistered phones. 

IF anybody get my question please do answere this issue. 

[Ayodeji Okanlawon]

Question 1: This is because the phones have registered to the publisher at some point. There is a field called "RegStatusChg TimeStamp". This is an epoch time and will tell you when the phone last registered or unregistered.

Question 2:

#TotalPhones	#TotalRegistered	#RegisteredSCCP	#RegisteredSIP	#UnRegistered	#Rejected	#PartiallyRegistered	StateId	#ExpUnreg
473	462	462	0	11	0	0	72480	0

The tables show you how many phones are registered and how many un registered. In this case you can see that the total is 473 but only 462 are registered on this server. So you know how many you have on this particular server.

[yadwindersingh]

Hi Ayodeji ,

Thanks for your information.

I would like to know is there any way to remove the unregistered phones from publisher which are registered with any subscriber.

Would appreciate if you have any other query because I need the exact count of unregistered and registered phones details on publisher and subscribers.

Regards,

Yadi