<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">
How about a BAT/BPS export?
<div><br>
</div>
<div>-w<br>
<div><br>
<div>On May 25, 2023, at 2:26 PM, Tim Reimers <treimers@ashevillenc.gov> wrote:</div>
<br class="Apple-interchange-newline">
<div>
<div dir="ltr">Sorry, sent before being ready...
<div><br>
</div>
<div>What I was hoping for was a list of all the registered active ATAs that would INCLUDE the DN on them.</div>
<div>As it is -- if I simply use the admin website, as you said, I can get a list of all the devices that are registered.<br>
</div>
<div><br>
</div>
<div>I've actually got the individual ATAs downloaded that way, and sorted by "Registered" in a Google Sheet.</div>
<div><br>
</div>
<div>I cannot easily also match those up with the DNs.</div>
<div>I suppose one could probably then write some sort of SQL command that would specify a long-ish list of ATA device names to query for DN.<br>
</div>
<div><br>
</div>
<div>It may be time to just ask an Intern to click on each ATA that's registered and collect the DN and description.</div>
<div><br>
</div>
<div>I thought about asking one of our DB people to do that -- </div>
<div>But they'd want a project set up, and require a complete list of the table schema, the IP/TCP port and data connection, etc</div>
<div>to do things as they're used to, with a direct SQL connection to query against.</div>
<div>They're not used to having to operate the way Cisco does with CLI only access to SQL in a limited fashion. </div>
<div>And I get why Cisco does that... not arguing that point.</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Thu, May 25, 2023 at 2:18 PM Tim Reimers <<a href="mailto:treimers@ashevillenc.gov">treimers@ashevillenc.gov</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 dir="ltr">Nate, I may have to do that.
<div><br>
</div>
<div>I just thought I was crazy that ATAs don't show up in </div>
<div>show risdb query phone</div>
<div><br>
</div>
<div>T</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Thu, May 25, 2023 at 2:08 PM <<a href="mailto:nateccie@gmail.com" target="_blank">nateccie@gmail.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>
<div lang="EN-US">
<div>
<p class="MsoNormal"><span style="font-size:11pt">What is the goal? I usually get what I want from device/phone, copy it all into the clipboard and paste without formatting into excel and continue on. In older versions of CUCM you can change the rows per
page, then edit the URL to make rows per page all of the devices on the system up to many thousands.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p>
<div>
<div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid rgb(225,225,225);padding:3pt 0in 0in">
<p class="MsoNormal"><b><span style="font-size:11pt">From:</span></b><span style="font-size:11pt"> cisco-voip <<a href="mailto:cisco-voip-bounces@puck.nether.net" target="_blank">cisco-voip-bounces@puck.nether.net</a>>
<b>On Behalf Of </b>Ryan Ratliff (rratliff)<br>
<b>Sent:</b> Thursday, May 25, 2023 10:46 AM<br>
<b>To:</b> Tim Reimers <<a href="mailto:treimers@ashevillenc.gov" target="_blank">treimers@ashevillenc.gov</a>>; Wes Sisk (wsisk) <<a href="mailto:wsisk@cisco.com" target="_blank">wsisk@cisco.com</a>><br>
<b>Cc:</b> cisco-voip <<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a>><br>
<b>Subject:</b> Re: [cisco-voip] Question about RISDB queries and ATA devices?<u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span style="font-size:11pt">I’m not surprised the “phone” filter only shows you SEP devices. I was expecting RTMT to give you a friendlier way to browse around and find the ATAs.
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p>
<p class="MsoNormal" style="margin-bottom:12pt"><span style="font-size:11pt">Do any of the other risdb CLI filters give you those devices?
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt">Interrogating the API directly is another option.
<br>
<a href="https://developer.cisco.com/docs/sxml/#!risport70-api-reference/selectcmdevice" target="_blank">https://developer.cisco.com/docs/sxml/#!risport70-api-reference/selectcmdevice</a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt">-Ryan<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p>
<div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid rgb(181,196,223);padding:3pt 0in 0in">
<p class="MsoNormal" style="margin-bottom:12pt"><b><span style="font-size: 12pt;">From:
</span></b><span style="font-size: 12pt;">cisco-voip <<a href="mailto:cisco-voip-bounces@puck.nether.net" target="_blank">cisco-voip-bounces@puck.nether.net</a>> on behalf of Tim Reimers <<a href="mailto:treimers@ashevillenc.gov" target="_blank">treimers@ashevillenc.gov</a>><br>
<b>Date: </b>Thursday, May 25, 2023 at 12:06 PM<br>
<b>To: </b>Wes Sisk (wsisk) <<a href="mailto:wsisk@cisco.com" target="_blank">wsisk@cisco.com</a>><br>
<b>Cc: </b>cisco-voip <<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a>><br>
<b>Subject: </b>Re: [cisco-voip] Question about RISDB queries and ATA devices?<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11pt">Hi Wes, Ryan, all<u></u><u></u></span></p>
<div>
<p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11pt">I'm not seeing any of the registered ATAs showing up in RTMT under a Device Search either -- only SEP devices.<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11pt">I gather that you are all expecting that 'show risdb query phone' as well as RTMT should be showing the ATAs registered and counted alongside the SEP devices<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11pt">so long as the ATAs are running in SCCP mode and not something else...<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11pt">Thanks Tim<u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p>
<div>
<div>
<p class="MsoNormal"><span style="font-size:11pt">On Thu, May 25, 2023 at 10:17 AM Wes Sisk (wsisk) <<a href="mailto:wsisk@cisco.com" target="_blank">wsisk@cisco.com</a>> wrote:<u></u><u></u></span></p>
</div>
<blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid rgb(204,204,204);padding:0in 0in 0in 6pt;margin:5pt 0in 5pt 4.8pt">
<div>
<p class="MsoNormal"><span style="font-size:11pt">Yes, registration information is in RIS not in SQL(informix). I see some other mentions of this, but not clear resolution.
<u></u><u></u></span></p>
<div>
<p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11pt">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?<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11pt">Oh, and ATAs could be h.323 for a while, so are they registering as SCCP?<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11pt">-w<u></u><u></u></span></p>
<div>
<p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p>
<div>
<p class="MsoNormal"><span style="font-size:11pt">On May 25, 2023, at 9:50 AM, Tim Reimers <<a href="mailto:treimers@ashevillenc.gov" target="_blank">treimers@ashevillenc.gov</a>> wrote:<u></u><u></u></span></p>
</div>
<p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p>
<div>
<div>
<p class="MsoNormal"><span style="font-size:11pt">Hi all - <u></u><u></u></span></p>
<div>
<p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11pt">I'm trying to find the ACTIVELY REGISTERED devices on my UCM 9.1 system.<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11pt">I need to find the list of actively registered ATA 186 devices and their DNs.<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11pt">* I'm using "show risdb query phones" command, as documented here among other sites<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11pt"><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><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11pt">That seems to show only the SEPxxxxyyyyzzz devices, aka my 79XX SCCP phones.<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11pt">I don't see any ATAxxxxyyyyzzzz devices being returned.<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11pt">Are they not in the "phone" table of the RISDB?<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11pt">Thanks, Tim<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11pt">* my understanding is that any variation on the "run sql select" is<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11pt">simply querying the Oracle? database for _configured_ devices only, and isn't looking <u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11pt">at the memory table of the Callmanager process to see the _currently registered_ devices.<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11pt">(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).<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11pt"><br clear="all">
<u></u><u></u></span></p>
<div>
<p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p>
</div>
<p class="MsoNormal"><span style="font-size:11pt">-- <u></u><u></u></span></p>
<div>
<div>
<div>
<div>
<p><b><i><span lang="EN" style="font-size:10pt;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:10pt;font-family:Arial,sans-serif;color:blue"> nexus</span></i></b><u></u><u></u></p>
<p>Tim Reimers<u></u><u></u></p>
<p>Network Administrator<u></u><u></u></p>
<p>I.T Services<u></u><u></u></p>
<p>City of Asheville <u></u><u></u></p>
<p><a href="mailto:treimers@ashevillenc.gov" target="_blank">treimers@ashevillenc.gov</a><u></u><u></u></p>
<p>(desk) 828-259-5512<u></u><u></u></p>
<p>(cell) 828-552-1585<u></u><u></u></p>
<p>"<span style="font-family:"Helvetica Neue";color:rgb(25,25,25)">That’s no ordinary
<s>rabbit</s></span> <span style="font-family:"Helvetica Neue";color:rgb(25,25,25)">
packet! That’s the most foul, cruel, and bad tempered </span>badly framed<span style="font-family:"Helvetica Neue";color:rgb(25,25,25)"> 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:rgb(25,25,25)">.</span><span style="font-family:"Helvetica Neue";color:rgb(25,25,25)">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:rgb(25,25,25)">
</span><span style="font-family:"Helvetica Neue";color:rgb(25,25,25)">packet on the network, isn’t it now...."</span><u></u><u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><span style="font-size:11pt">_______________________________________________<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><u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p>
</div>
</div>
</blockquote>
</div>
<p class="MsoNormal"><span style="font-size:11pt"><br clear="all">
<u></u><u></u></span></p>
<div>
<p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p>
</div>
<p class="MsoNormal"><span><span style="font-size:11pt">-- </span></span><span style="font-size:11pt"><u></u><u></u></span></p>
<div>
<div>
<div>
<div>
<p><b><i><span lang="EN" style="font-size:10pt;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:10pt;font-family:Arial,sans-serif;color:blue"> nexus</span></i></b><u></u><u></u></p>
<p>Tim Reimers<u></u><u></u></p>
<p>Network Administrator<u></u><u></u></p>
<p>I.T Services<u></u><u></u></p>
<p>City of Asheville <u></u><u></u></p>
<p><a href="mailto:treimers@ashevillenc.gov" target="_blank">treimers@ashevillenc.gov</a><u></u><u></u></p>
<p>(desk) 828-259-5512<u></u><u></u></p>
<p>(cell) 828-552-1585<u></u><u></u></p>
<p>"<span style="font-family:"Helvetica Neue";color:rgb(25,25,25)">That’s no ordinary
<s>rabbit</s></span> <span style="font-family:"Helvetica Neue";color:rgb(25,25,25)">
packet! That’s the most foul, cruel, and bad tempered </span>badly framed<span style="font-family:"Helvetica Neue";color:rgb(25,25,25)"> 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:rgb(25,25,25)">.</span><span style="font-family:"Helvetica Neue";color:rgb(25,25,25)">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:rgb(25,25,25)">
</span><span style="font-family:"Helvetica Neue";color:rgb(25,25,25)">packet on the network, isn’t it now...."</span><u></u><u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</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>
</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>
</div>
</div>
<br>
</div>
</body>
</html>