<html><head><base href="x-msg://240/"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">I believe there is some misunderstanding here. 'show risdb query' queries the shared memory segment on the local server. that shared memory is maintained by the local ccm process. That shared memory contains the registration status of the phones relative to the local node.<div><br></div><div>If a phone is registered to node1 it should appear in show risdb on node1 as registered. If the phone failed over to node2 and then failed back to node1 then show risdb on node2 would show the phone as unregistered. If ccm is restarted on node2 then the shared memory on node2 is cleared and node2 ris forgets the phone has ever registered there.</div><div><br></div><div>This is simply status for ris and the shared memory segment. Internal to the ccm process there is a "process" called DeviceManager that maintains device registration status across the entire cluster. DeviceManager on node2 knows the phone is registered to node1 so calls that originate on node2 can route to the phone.</div><div><br></div><div>The shared memory segment accessed with 'show risdb' only matches device manager status for locally registered phones. it does not include remote registrations. The only way the counts and constituent phones on each node would match is if all phones had registered to both nodes since the last time the ccm process was restarted on both nodes. This is likely to happen in a mass failover due to loss of network connectivity to a primary cucm server.</div><div><br></div><div><div><br></div><div>An example might help. Here I login to each node in the cluster and check output. In the below sample you can see the phone SEP001121FF9474 is currently registered to 10.18.172.204 but it has registered, and subsequently unregistered, with 10.18.172.205 since the last time the ccm process was restarted on the node 10.18.172.205.<div><br></div><div><br></div><div><div><font class="Apple-style-span" face="'Courier New'">mymac:uc wsisk$ ssh administrator@10.18.172.204</font></div><div><font class="Apple-style-span" face="'Courier New'">administrator@10.18.172.204's password: </font></div><div><font class="Apple-style-span" face="'Courier New'">Command Line Interface is starting up, please wait ...</font></div><div><font class="Apple-style-span" face="'Courier New'"><br></font></div><div><font class="Apple-style-span" face="'Courier New'"> Welcome to the Platform Command Line Interface</font></div><div><font class="Apple-style-span" face="'Courier New'"><br></font></div><div><font class="Apple-style-span" face="'Courier New'">VMware Installation:</font></div><div><font class="Apple-style-span" face="'Courier New'"><span class="Apple-tab-span" style="white-space:pre"> </span>1 vCPU: Intel(R) Xeon(R) CPU X5680 @ 3.33GHz</font></div><div><font class="Apple-style-span" face="'Courier New'"><span class="Apple-tab-span" style="white-space:pre"> </span>Disk 1: 72GB</font></div><div><font class="Apple-style-span" face="'Courier New'"><span class="Apple-tab-span" style="white-space:pre"> </span>2048 Mbytes RAM</font></div><div><font class="Apple-style-span" face="'Courier New'"><br></font></div><div><font class="Apple-style-span" face="'Courier New'">admin:run sql select name from processnode</font></div><div><font class="Apple-style-span" face="'Courier New'">name </font></div><div><font class="Apple-style-span" face="'Courier New'">================== </font></div><div><font class="Apple-style-span" face="'Courier New'">EnterpriseWideData </font></div><div><font class="Apple-style-span" face="'Courier New'">10.18.172.204 </font></div><div><font class="Apple-style-span" face="'Courier New'">10.18.172.205 </font></div><div><font class="Apple-style-span" face="'Courier New'">10.18.172.206 </font></div><div><font class="Apple-style-span" face="'Courier New'">admin:show risdb query phone</font></div><div><font class="Apple-style-span" face="'Courier New'">----------- Phone Information -----------</font></div><div><font class="Apple-style-span" face="'Courier New'"><br></font></div><div><font class="Apple-style-span" face="'Courier New'">#TotalPhones, #TotalRegistered, #RegisteredSCCP, #RegisteredSIP, #UnRegistered, #Rejected, #PartiallyRegistered, StateId, #ExpUnreg</font></div><div><font class="Apple-style-span" face="'Courier New'">15, 12, 9, 3, 3, 0, 0, 28,0</font></div><div><font class="Apple-style-span" face="'Courier New'"><br></font></div><div><font class="Apple-style-span" face="'Courier New'">DeviceName, Descr, Ipaddr, Ipv6addr, Ipv4Attr, Ipv6Attr, MACaddr, RegStatus, PhoneProtocol, DeviceModel, HTTPsupport, #regAttempts, prodId, username, seq#, RegStatusChg TimeStamp, IpAddrType, LoadId, ActiveLoadId, InactiveLoadId, ReqLoadId, DnldServer, DnldStatus, DnldFailReason, LastActTimeStamp </font></div><div><font class="Apple-style-span" face="'Courier New'">SEP44E4D9449BB4, Auto 86274, 14.48.27.61, , 0, 0, 44E4D9449BB4, reg, SIP, 493, yes, 0, 380, NoUserId, 1, 1330632927, 1, sip9971.9-2-1, sip9971.9-2-1, sip9971.9-2-3-27, , , 0, , 1330632927</font></div><div><font class="Apple-style-span" face="'Courier New'">...<abbreviated>...</font></div><div><font class="Apple-style-span" face="'Courier New'">SEP001121FF9474, Auto 86204, 14.48.30.11, , 3, 0, 001121FF9474, reg, SCCP, 495, yes, 0, 382, NoUserId, 15, 1330633090, 1, SCCP69xx.9-2-1-0, SCCP69xx.9-2-1-0, , , , 0, , 1330633090</font></div><div><font class="Apple-style-span" face="'Courier New'">----------------</font></div><div><font class="Apple-style-span" face="'Courier New'">Total count 15</font></div><div><font class="Apple-style-span" face="'Courier New'">----------------</font></div><div><font class="Apple-style-span" face="'Courier New'">admin:quit</font></div><div><font class="Apple-style-span" face="'Courier New'"><br></font></div><div><font class="Apple-style-span" face="'Courier New'">Connection to 10.18.172.204 closed.</font></div><div><font class="Apple-style-span" face="'Courier New'">mymac:uc wsisk$ ssh administrator@10.18.172.205</font></div><div><font class="Apple-style-span" face="'Courier New'">administrator@10.18.172.205's password: </font></div><div><font class="Apple-style-span" face="'Courier New'">Command Line Interface is starting up, please wait ...</font></div><div><font class="Apple-style-span" face="'Courier New'"><br></font></div><div><font class="Apple-style-span" face="'Courier New'"> Welcome to the Platform Command Line Interface</font></div><div><font class="Apple-style-span" face="'Courier New'"><br></font></div><div><font class="Apple-style-span" face="'Courier New'">VMware Installation:</font></div><div><font class="Apple-style-span" face="'Courier New'"><span class="Apple-tab-span" style="white-space:pre"> </span>1 vCPU: Intel(R) Xeon(R) CPU X5680 @ 3.33GHz</font></div><div><font class="Apple-style-span" face="'Courier New'"><span class="Apple-tab-span" style="white-space:pre"> </span>Disk 1: 72GB</font></div><div><font class="Apple-style-span" face="'Courier New'"><span class="Apple-tab-span" style="white-space:pre"> </span>2048 Mbytes RAM</font></div><div><font class="Apple-style-span" face="'Courier New'"><br></font></div><div><font class="Apple-style-span" face="'Courier New'">admin:show risdb query phone</font></div><div><font class="Apple-style-span" face="'Courier New'">----------- Phone Information -----------</font></div><div><font class="Apple-style-span" face="'Courier New'"><br></font></div><div><font class="Apple-style-span" face="'Courier New'">#TotalPhones, #TotalRegistered, #RegisteredSCCP, #RegisteredSIP, #UnRegistered, #Rejected, #PartiallyRegistered, StateId, #ExpUnreg</font></div><div><font class="Apple-style-span" face="'Courier New'">13, 0, 0, 0, 13, 0, 0, 30,0</font></div><div><font class="Apple-style-span" face="'Courier New'"><br></font></div><div><font class="Apple-style-span" face="'Courier New'">DeviceName, Descr, Ipaddr, Ipv6addr, Ipv4Attr, Ipv6Attr, MACaddr, RegStatus, PhoneProtocol, DeviceModel, HTTPsupport, #regAttempts, prodId, username, seq#, RegStatusChg TimeStamp, IpAddrType, LoadId, ActiveLoadId, InactiveLoadId, ReqLoadId, DnldServer, DnldStatus, DnldFailReason, LastActTimeStamp </font></div><div><font class="Apple-style-span" face="'Courier New'">SEP001121FF9474, Auto 86204, 14.48.30.11, , 3, 0, 001121FF9474, unr, SCCP, 495, yes, 0, 382, NoUserId, 1, 1330633084, 1, SCCP69xx.9-2-1-0, SCCP69xx.9-2-1-0, , , , 0, , 1330633084</font></div><div><font class="Apple-style-span" face="'Courier New'">...<abbreviated>...</font></div><div><font class="Apple-style-span" face="'Courier New'">SEP88F07788A774, Auto 86275, 14.48.64.46, , 0, 0, 88F07788A774, unr, SIP, 493, yes, 0, 380, NoUserId, 13, 1330633042, 1, sip9971.9-2-1, sip9971.9-2-1, sip9971.9-2-3-27, , , 0, , 1330633042</font></div><div><font class="Apple-style-span" face="'Courier New'"><br></font></div><div><font class="Apple-style-span" face="'Courier New'">----------------</font></div><div><font class="Apple-style-span" face="'Courier New'">Total count 13</font></div><div><font class="Apple-style-span" face="'Courier New'">----------------</font></div><div><font class="Apple-style-span" face="'Courier New'">admin:quit</font></div><div><font class="Apple-style-span" face="'Courier New'"><br></font></div><div><font class="Apple-style-span" face="'Courier New'">Connection to 10.18.172.205 closed.</font></div><div><font class="Apple-style-span" face="'Courier New'">mymac:uc wsisk$ ssh administrator@10.18.172.206</font></div><div><font class="Apple-style-span" face="'Courier New'">administrator@10.18.172.206's password: </font></div><div><font class="Apple-style-span" face="'Courier New'">Command Line Interface is starting up, please wait ...</font></div><div><font class="Apple-style-span" face="'Courier New'"><br></font></div><div><font class="Apple-style-span" face="'Courier New'"> Welcome to the Platform Command Line Interface</font></div><div><font class="Apple-style-span" face="'Courier New'"><br></font></div><div><font class="Apple-style-span" face="'Courier New'">VMware Installation:</font></div><div><font class="Apple-style-span" face="'Courier New'"><span class="Apple-tab-span" style="white-space:pre"> </span>1 vCPU: Intel(R) Xeon(R) CPU X5680 @ 3.33GHz</font></div><div><font class="Apple-style-span" face="'Courier New'"><span class="Apple-tab-span" style="white-space:pre"> </span>Disk 1: 72GB</font></div><div><font class="Apple-style-span" face="'Courier New'"><span class="Apple-tab-span" style="white-space:pre"> </span>2048 Mbytes RAM</font></div><div><font class="Apple-style-span" face="'Courier New'"><br></font></div><div><font class="Apple-style-span" face="'Courier New'">admin:</font></div><div><font class="Apple-style-span" face="'Courier New'">admin:show risdb query phone</font></div><div><font class="Apple-style-span" face="'Courier New'">----------- Phone Information -----------</font></div><div><font class="Apple-style-span" face="'Courier New'"><br></font></div><div><font class="Apple-style-span" face="'Courier New'">#TotalPhones, #TotalRegistered, #RegisteredSCCP, #RegisteredSIP, #UnRegistered, #Rejected, #PartiallyRegistered, StateId, #ExpUnreg</font></div><div><font class="Apple-style-span" face="'Courier New'">2, 0, 0, 0, 2, 0, 0, 4,0</font></div><div><font class="Apple-style-span" face="'Courier New'"><br></font></div><div><font class="Apple-style-span" face="'Courier New'">DeviceName, Descr, Ipaddr, Ipv6addr, Ipv4Attr, Ipv6Attr, MACaddr, RegStatus, PhoneProtocol, DeviceModel, HTTPsupport, #regAttempts, prodId, username, seq#, RegStatusChg TimeStamp, IpAddrType, LoadId, ActiveLoadId, InactiveLoadId, ReqLoadId, DnldServer, DnldStatus, DnldFailReason, LastActTimeStamp </font></div><div><font class="Apple-style-span" face="'Courier New'">SEP001121FF9C3F, Auto 86203, 14.48.64.42, , 3, 0, 001121FF9C3F, unr, SCCP, 496, yes, 0, 383, NoUserId, 1, 1330632834, 1, SCCP69xx.9-2-1-0, SCCP69xx.9-2-1-0, , , , 0, , 1330632834</font></div><div><font class="Apple-style-span" face="'Courier New'">SEP001121FF9474, Auto 86204, 14.48.30.11, , 3, 0, 001121FF9474, unr, SCCP, 495, yes, 0, 382, NoUserId, 2, 1330632834, 1, SCCP69xx.9-2-1-0, SCCP69xx.9-2-1-0, , , , 0, , 1330632834</font></div><div><font class="Apple-style-span" face="'Courier New'"><br></font></div><div><font class="Apple-style-span" face="'Courier New'">----------------</font></div><div><font class="Apple-style-span" face="'Courier New'">Total count 2</font></div><div><font class="Apple-style-span" face="'Courier New'">----------------</font></div><div><font class="Apple-style-span" face="'Courier New'">admin:quit</font></div><div><font class="Apple-style-span" face="'Courier New'"><br></font></div><div><font class="Apple-style-span" face="'Courier New'"><br></font></div></div><div>Regards,</div><div>Wes</div><div><br></div><div><br><div><div><div>On Mar 2, 2012, at 11:16 AM, Wesley Schochet wrote:</div><br class="Apple-interchange-newline"><div style="margin-top: 4px; margin-right: 4px; margin-bottom: 1px; margin-left: 4px; font: normal normal normal 10pt/normal Tahoma; ">No, the total says 18 - it should be about 350. I get exactly the same results on the Pub and ach of the subs.<br><br>>>> On 3/1/2012 at 1:41 PM, Lelio Fulgenzi <<a href="mailto:lelio@uoguelph.ca">lelio@uoguelph.ca</a>> wrote:<br><table border="0" bgcolor="#f3f3f3" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 15px; font-size: 1em; "><tbody><tr><td><div style="border-left-color: rgb(5, 5, 5); border-left-width: 1px; border-left-style: solid; padding-left: 7px; "><div style="font-family: Verdana; color: rgb(0, 0, 0); font-size: 10pt; ">ok. this is a really silly question, but it bit me.<br><br>what terminal package are you using to capture the information? also, what are you using to open the capture file?<br><br>if you use putty and configure to log the output and then use something like wordpad to open the file, you might see different results.<br><br>is the Total Count that's at the end what you expect?<br><br><span><br><span name="x"></span>---<br>Lelio Fulgenzi, B.A.<br>Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1<br>(519) 824-4120 x56354 (519) 767-1060 FAX (ANNU)<br>^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^<br>Cooking with unix is easy. You just sed it and forget it.<span class="Apple-converted-space"> </span><br> - LFJ (with apologies to Mr. Popeil)<br><span name="x"></span><br></span><br><hr id="zwchr"><b>From:<span class="Apple-converted-space"> </span></b>"Wesley Schochet" <<a href="mailto:Wesley.Schochet@childrensmn.org">Wesley.Schochet@childrensmn.org</a>><br><b>To:<span class="Apple-converted-space"> </span></b><a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br><b>Sent:<span class="Apple-converted-space"> </span></b>Thursday, March 1, 2012 12:54:47 PM<br><b>Subject:<span class="Apple-converted-space"> </span></b>[cisco-voip] risdb query<br><br><div>Hi all-</div><div> </div><div>I am trying to understand this risdb query. When I issue the cli command</div><div> </div><div>show risdb query phone</div><div> </div><div>I get a list of 18 phones. However, there are several hundred in my system, most of which are registered. Is there something I am missing with this command? I have tried it from the pub and the subs and get identical results.</div><div> </div><div>Thanks</div><div> </div><div> </div><div>Wesley A. Schochet</div><div>System Architect</div><div>Children's of Minnesota<br><font face="Wingdings">+<span class="Apple-converted-space"> </span></font><a href="mailto:wes.schochet@childrensmn.org" target="_blank">wes.schochet@childrensmn.org<br></a><font size="4"><font face="Wingdings">(</font></font> 651-855-2081<br><font size="5" face="Webdings">È</font> 651-592-5441</div><font face="monospace"><br>Confidentiality Statement:<br>This email/fax, including attachments, may include confidential<br>and/or proprietary information and may be used only by the<br>person or entity to which it is addressed. If the reader of<span class="Apple-converted-space"> </span><br>this email/fax is not the intended recipient or his or her<span class="Apple-converted-space"> </span><br>agent, the reader is hereby notified that any dissemination,<span class="Apple-converted-space"> </span><br>distribution or copying of this email/fax is prohibited. If you<span class="Apple-converted-space"> </span><br>have received this email/fax in error, please notify the sender<span class="Apple-converted-space"> </span><br>by replying to this message and deleting this email or<span class="Apple-converted-space"> </span><br>destroying this facsimile immediately.</font><span class="Apple-converted-space"> </span><br>_______________________________________________<br>cisco-voip mailing list<br><a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br><a href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br></div></div></td></tr></tbody></table><font face="monospace"><br>Confidentiality Statement:<br>This email/fax, including attachments, may include confidential<br>and/or proprietary information and may be used only by the<br>person or entity to which it is addressed. If the reader of<span class="Apple-converted-space"> </span><br>this email/fax is not the intended recipient or his or her<span class="Apple-converted-space"> </span><br>agent, the reader is hereby notified that any dissemination,<span class="Apple-converted-space"> </span><br>distribution or copying of this email/fax is prohibited. If you<span class="Apple-converted-space"> </span><br>have received this email/fax in error, please notify the sender<span class="Apple-converted-space"> </span><br>by replying to this message and deleting this email or<span class="Apple-converted-space"> </span><br>destroying this facsimile immediately.</font><span class="Apple-converted-space"> </span>_______________________________________________<br>cisco-voip mailing list<br><a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br><a href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br></div></div><br></div></div></div></div></body></html>