<div dir="ltr">Hi Ryan, Wes, all --<div><br></div><div>I only have two nodes, and am checking both....</div><div>I wondered if they're registering as SCCP or H.323, so I looked at H.323 as well - no show there either, only gateway devices.<br></div><div><br></div><div>In UCM web interface under Device>Phones dialog, there are ATAs registered.</div><div><br></div><div>Device Protocol shows as SCCP.</div><div>Firmware on one selected at random ATA is</div>ATA030203SCCP051201A.zup<div><br></div><div>A view of </div><b>admin:show risdb query phoneextn</b><div><b><br></b></div><div><b>also does not find the DN of any given ATA that I can otherwise find in the Device</b></div><div><b><br></b></div><div><b>I'm not sure what you mean in terms of RTMT.</b></div><div><b>That shows the number of registered phones -- </b></div><div><b>When I did a Device Search, I didn't see a way to select ATAs in specific - just all other models of device</b></div><div><b>(which didn't work either, so I guess I was doing something wrong somehow)</b></div><div><b><br></b></div><div><b>Thanks Tim<br></b><div><br></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, May 25, 2023 at 10:17 AM Wes Sisk (wsisk) <<a href="mailto:wsisk@cisco.com">wsisk@cisco.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
Yes, registration information is in RIS not in SQL(informix). I see some other mentions of this, but not clear resolution.
<div><br>
</div>
<div>Note that ATA may follow different CM server resolution and 'show risdb' is per-node. Aka, have you checked all nodes with CM service activated where ATAs might be registered?</div>
<div><br>
</div>
<div>Oh, and ATAs could be h.323 for a while, so are they registering as SCCP?</div>
<div><br>
</div>
<div>-w<br>
<div><br>
<div>On May 25, 2023, at 9:50 AM, Tim Reimers <<a href="mailto:treimers@ashevillenc.gov" target="_blank">treimers@ashevillenc.gov</a>> wrote:</div>
<br>
<div>
<div dir="ltr">Hi all -
<div><br>
</div>
<div>I'm trying to find the ACTIVELY REGISTERED devices on my UCM 9.1 system.</div>
<div><br>
</div>
<div>I need to find the list of actively registered ATA 186 devices and their DNs.</div>
<div><br>
</div>
<div>* I'm using "show risdb query phones" command, as documented here among other sites</div>
<div><a href="https://getpractical.co.uk/2021/10/11/cisco-cucm-reports-from-sql-show-risdb/" target="_blank">https://getpractical.co.uk/2021/10/11/cisco-cucm-reports-from-sql-show-risdb/</a><br>
</div>
<div><br>
</div>
<div>That seems to show only the SEPxxxxyyyyzzz devices, aka my 79XX SCCP phones.</div>
<div><br>
</div>
<div>I don't see any ATAxxxxyyyyzzzz devices being returned.</div>
<div>Are they not in the "phone" table of the RISDB?</div>
<div><br>
</div>
<div>Thanks, Tim</div>
<div><br>
</div>
<div>* my understanding is that any variation on the "run sql select" is</div>
<div>simply querying the Oracle? database for _configured_ devices only, and isn't looking </div>
<div>at the memory table of the Callmanager process to see the _currently registered_ devices.</div>
<div>(I've seen a number of other forum posts where people suggested "run sql" commands to gather info, but that is statically configured, not necessarily "registered", so that does not seem appropriate for the info I want).</div>
<div><br>
</div>
<div><br clear="all">
<div><br>
</div>
<span>-- </span><br>
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<p><b><i><span lang="EN" style="color:blue;font-family:Arial,sans-serif;font-size:10pt"><span style="color:blue"><a href="https://en.wikipedia.org/wiki/Quis_custodiet_ipsos_custodes%3F" target="_blank">Quis custodiet
</a>ipsos</span></span></i></b><b><i><span style="color:blue;font-family:Arial,sans-serif;font-size:10pt"> nexus</span></i></b><b><i><span style="color:blue;font-family:Arial,sans-serif;font-size:10pt"></span></i></b></p>
<p>Tim Reimers</p>
<p>Network Administrator</p>
<p>I.T Services</p>
<p>City of Asheville </p>
<p><a href="mailto:treimers@ashevillenc.gov" target="_blank">treimers@ashevillenc.gov</a></p>
<p>(desk) 828-259-5512</p>
<p>(cell) 828-552-1585</p>
<p>"<span style="color:rgb(25,25,25);font-family:alright_sansregular,"Helvetica Neue",Helvetica,Arial,sans-serif">That’s no ordinary
<strike>rabbit</strike></span> <span style="color:rgb(25,25,25);font-family:alright_sansregular,"Helvetica Neue",Helvetica,Arial,sans-serif">
packet! That’s the most foul, cruel, and bad tempered </span>badly framed<span style="color:rgb(25,25,25);font-family:alright_sansregular,"Helvetica Neue",Helvetica,Arial,sans-serif"> packet you ever set eyes on. </span><span style="color:rgb(25,25,25);font-family:alright_sansregular,"Helvetica Neue",Helvetica,Arial,sans-serif">Listen,
that packet’s got a vicious streak a mile wide, he’s a killer</span><span style="color:rgb(25,25,25);font-family:alright_sansregular,"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:18px">.</span><span style="color:rgb(25,25,25);font-family:alright_sansregular,"Helvetica Neue",Helvetica,Arial,sans-serif">He’s
got huge sharp MTU…eh, he can leap about and cross Vlans…. </span><span style="color:rgb(25,25,25);font-family:alright_sansregular,"Helvetica Neue",Helvetica,Arial,sans-serif">I warned you, I warned you but did you listen? No… ohhh no, it’s just a harmless
little<font size="4"> </font>packet on the network, isn’t it now....</span><span style="color:rgb(25,25,25);font-family:alright_sansregular,"Helvetica Neue",Helvetica,Arial,sans-serif">"</span></p>
</div>
</div>
</div>
</div>
</div>
</div>
_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
</div>
</div>
<br>
</div>
</div>
</blockquote></div><br clear="all"><div><br></div><span class="gmail_signature_prefix">-- </span><br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div dir="ltr"><div dir="ltr"><p><b><i><span lang="EN" style="color:blue;font-family:Arial,sans-serif;font-size:10pt"><span style="color:blue"><a href="https://en.wikipedia.org/wiki/Quis_custodiet_ipsos_custodes%3F" target="_blank">Quis custodiet
</a>ipsos</span></span></i></b><b><i><span style="color:blue;font-family:Arial,sans-serif;font-size:10pt"> nexus</span></i></b><b><i><span style="color:blue;font-family:Arial,sans-serif;font-size:10pt"></span></i></b></p>
<p>Tim Reimers</p>
<p>Network Administrator</p>
<p>I.T Services</p>
<p>City of Asheville </p>
<p><a href="mailto:treimers@ashevillenc.gov" target="_blank">treimers@ashevillenc.gov</a></p>
<p>(desk) 828-259-5512</p>
<p>(cell) 828-552-1585</p>
<p>"<span style="color:rgb(25,25,25);font-family:alright_sansregular,"Helvetica Neue",Helvetica,Arial,sans-serif">That’s no ordinary <strike>rabbit</strike></span> <span style="color:rgb(25,25,25);font-family:alright_sansregular,"Helvetica Neue",Helvetica,Arial,sans-serif">packet! That’s the most foul, cruel, and bad tempered </span>badly framed<span style="color:rgb(25,25,25);font-family:alright_sansregular,"Helvetica Neue",Helvetica,Arial,sans-serif"> packet you ever set eyes on. </span><span style="color:rgb(25,25,25);font-family:alright_sansregular,"Helvetica Neue",Helvetica,Arial,sans-serif">Listen, that packet’s got a vicious streak a mile wide, he’s a killer</span><span style="color:rgb(25,25,25);font-family:alright_sansregular,"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:18px">.</span><span style="color:rgb(25,25,25);font-family:alright_sansregular,"Helvetica Neue",Helvetica,Arial,sans-serif">He’s got huge sharp MTU…eh, he can leap about and cross Vlans…. </span><span style="color:rgb(25,25,25);font-family:alright_sansregular,"Helvetica Neue",Helvetica,Arial,sans-serif">I warned you, I warned you but did you listen? No… ohhh no, it’s just a harmless little<font size="4"> </font>packet on the network, isn’t it now....</span><span style="color:rgb(25,25,25);font-family:alright_sansregular,"Helvetica Neue",Helvetica,Arial,sans-serif">"</span></p></div></div></div></div>