<html xmlns:v="urn:schemas-microsoft-com:vml" 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";}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.m4744988686005538937gmailsignatureprefix
{mso-style-name:m_4744988686005538937gmailsignatureprefix;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal>It was broken in newer SUs of 11.5 and 12.5. I’ve relied on this for 20 years, and then it just went away. Oh well to the cloud we go.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b>From:</b> Jason Aarons <scubajasona@gmail.com> <br><b>Sent:</b> Thursday, May 25, 2023 12:40 PM<br><b>To:</b> NateCCIE <nateccie@gmail.com><br><b>Cc:</b> Ryan Ratliff (rratliff) <rratliff@cisco.com>; Tim Reimers <treimers@ashevillenc.gov>; Wes Sisk (wsisk) <wsisk@cisco.com>; cisco-voip <cisco-voip@puck.nether.net><br><b>Subject:</b> Re: [cisco-voip] Question about RISDB queries and ATA devices?<o:p></o:p></p></div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>It definitely sucks that CUCM 14 SU2 broke this. It was very helpful. Should be an easier way to export Devices } Phone to a csv file for download via GUI. But there is not.<o:p></o:p></p></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>On Thu, May 25, 2023, 8:09 PM <<a href="mailto:nateccie@gmail.com">nateccie@gmail.com</a>> wrote:<o:p></o:p></p></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in'><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>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.<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b>From:</b> 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?<o:p></o:p></p></div></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>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. <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt'>Do any of the other risdb CLI filters give you those devices? <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>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><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>-Ryan<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal style='mso-margin-top-alt:auto;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 <<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?</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Hi Wes, Ryan, all<o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>I'm not seeing any of the registered ATAs showing up in RTMT under a Device Search either -- only SEP devices.<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>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<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>so long as the ATAs are running in SCCP mode and not something else...<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Thanks Tim<o:p></o:p></p></div></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>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:<o:p></o:p></p></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Yes, registration information is in RIS not in SQL(informix). I see some other mentions of this, but not clear resolution. <o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>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?<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Oh, and ATAs could be h.323 for a while, so are they registering as SCCP?<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>-w<o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>On May 25, 2023, at 9:50 AM, Tim Reimers <<a href="mailto:treimers@ashevillenc.gov" target="_blank">treimers@ashevillenc.gov</a>> wrote:<o:p></o:p></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Hi all - <o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>I'm trying to find the ACTIVELY REGISTERED devices on my UCM 9.1 system.<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>I need to find the list of actively registered ATA 186 devices and their DNs.<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>* I'm using "show risdb query phones" command, as documented here among other sites<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>That seems to show only the SEPxxxxyyyyzzz devices, aka my 79XX SCCP phones.<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>I don't see any ATAxxxxyyyyzzzz devices being returned.<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Are they not in the "phone" table of the RISDB?<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Thanks, Tim<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>* my understanding is that any variation on the "run sql select" is<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>simply querying the Oracle? database for _configured_ devices only, and isn't looking <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>at the memory table of the Callmanager process to see the _currently registered_ devices.<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>(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></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><br clear=all><o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>-- <o:p></o:p></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><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>_______________________________________________<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><o:p></o:p></p></div></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div></div></blockquote></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><br clear=all><o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span class=m4744988686005538937gmailsignatureprefix>-- </span><o:p></o:p></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><p class=MsoNormal>_______________________________________________<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><o:p></o:p></p></blockquote></div></div></body></html>