<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Helvetica Neue";
panose-1:2 0 5 3 0 0 0 2 0 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:10.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.gmailsignatureprefix
{mso-style-name:gmail_signature_prefix;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body lang="EN-US" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt">You are on the right track looking in RIS. Have you poked around in RTMT yet?.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">-Ryan</span><span style="font-size:11.0pt"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal" style="margin-bottom:12.0pt"><b><span style="font-size:12.0pt;color:black">From:
</span></b><span style="font-size:12.0pt;color:black">cisco-voip <cisco-voip-bounces@puck.nether.net> on behalf of Tim Reimers <treimers@ashevillenc.gov><br>
<b>Date: </b>Thursday, May 25, 2023 at 9:51 AM<br>
<b>To: </b>cisco-voip <cisco-voip@puck.nether.net><br>
<b>Subject: </b>[cisco-voip] Question about RISDB queries and ATA devices?<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt">Hi all -<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt">I'm trying to find the ACTIVELY REGISTERED devices on my UCM 9.1 system.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt">I need to find the list of actively registered ATA 186 devices and their DNs.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt">* I'm using "show risdb query phones" command, as documented here among other sites<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt"><a href="https://getpractical.co.uk/2021/10/11/cisco-cucm-reports-from-sql-show-risdb/">https://getpractical.co.uk/2021/10/11/cisco-cucm-reports-from-sql-show-risdb/</a><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt">That seems to show only the SEPxxxxyyyyzzz devices, aka my 79XX SCCP phones.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt">I don't see any ATAxxxxyyyyzzzz devices being returned.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt">Are they not in the "phone" table of the RISDB?<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt">Thanks, Tim<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt">* my understanding is that any variation on the "run sql select" is<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt">simply querying the Oracle? database for _configured_ devices only, and isn't looking <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt">at the memory table of the Callmanager process to see the _currently registered_ devices.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt">(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).<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt"><br clear="all">
<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal"><span class="gmailsignatureprefix"><span style="font-size:11.0pt">--
</span></span><span style="font-size:11.0pt"><o:p></o:p></span></p>
<div>
<div>
<div>
<div>
<p><b><i><span lang="EN" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:blue"><a href="https://en.wikipedia.org/wiki/Quis_custodiet_ipsos_custodes%3F" target="_blank">Quis custodiet
</a>ipsos</span></i></b><b><i><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:blue"> nexus</span></i></b><o:p></o:p></p>
<p>Tim Reimers<o:p></o:p></p>
<p>Network Administrator<o:p></o:p></p>
<p>I.T Services<o:p></o:p></p>
<p>City of Asheville <o:p></o:p></p>
<p><a href="mailto:treimers@ashevillenc.gov" target="_blank">treimers@ashevillenc.gov</a><o:p></o:p></p>
<p>(desk) 828-259-5512<o:p></o:p></p>
<p>(cell) 828-552-1585<o:p></o:p></p>
<p>"<span style="font-family:"Helvetica Neue";color:#191919">That’s no ordinary <s>
rabbit</s></span> <span style="font-family:"Helvetica Neue";color:#191919">packet! That’s the most foul, cruel, and bad tempered </span>badly framed<span style="font-family:"Helvetica Neue";color:#191919"> packet you ever set eyes on. Listen, that packet’s
got a vicious streak a mile wide, he’s a killer</span><span style="font-size:13.5pt;font-family:"Helvetica Neue";color:#191919">.</span><span style="font-family:"Helvetica Neue";color:#191919">He’s got huge sharp MTU…eh, he can leap about and cross Vlans…. I
warned you, I warned you but did you listen? No… ohhh no, it’s just a harmless little</span><span style="font-size:13.5pt;font-family:"Helvetica Neue";color:#191919">
</span><span style="font-family:"Helvetica Neue";color:#191919">packet on the network, isn’t it now...."</span><o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>