<html><head></head><body><div class="ydpc8586f5byahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;"><div></div>
<div dir="ltr" data-setdir="false">Here is a SQL command I use to get a list of all the devices that includes device, primary number on the device and mac.</div><div dir="ltr" data-setdir="false">This will give you CTI route points also.</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false"><span>model<span style="white-space: pre-wrap;"> </span>mac<span style="white-space: pre-wrap;"> </span>description<span style="white-space: pre-wrap;"> </span>dnorpattern<span style="white-space: pre-wrap;"> </span>name</span><br></div><div dir="ltr" data-setdir="false"><span><br></span></div><div dir="ltr" data-setdir="false"><span><span>run sql select typemodel.name as model, device.name as mac, device.description, numplan.dnorpattern, devicepool.name from device join typemodel on device.tkmodel = typemodel.enum join devicenumplanmap on device.pkid = devicenumplanmap.fkdevice join numplan on devicenumplanmap.fknumplan = numplan.pkid join devicepool on device.fkdevicepool = devicepool.pkid where devicenumplanmap.numplanindex = '1'</span><br></span></div><div dir="ltr" data-setdir="false"><span><br></span></div><div><br></div>
</div><div id="ydpdc68a9e2yahoo_quoted_6574643416" class="ydpdc68a9e2yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Thursday, June 1, 2023, 08:26:36 AM MST, Tim Reimers <treimers@ashevillenc.gov> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id="ydpdc68a9e2yiv0529745845"><div dir="ltr">Hi all -<div>Thanks for the earlier assistance with obtaining details for ATAs.</div><div>Turned out the only way to do it is a screenscrape and check each one for the DN.</div><div><br></div><div>My next goal is:</div><div>How to know if there's a device of any kind attached to the port of an ATA-186.</div><br>I know for my VG-224 devices, I can do this:<br>VG224#test voice port 2/0 line-test phone-detection<br>measured result 0x20C48FB<br>AC current = 0421 uA<br>port 2/0 has phone connected<div><br></div><div>Does anyone know if there's anything similar in an ATA, like somewhere in the web interface</div><div>where a similar statistic is reported or a test available?</div><div><br></div><div>We've got a lot of these that are remote to us, and I need to figure out which</div><div>ones still have anything attached, and which ones are simply dead wire hanging off and the equipment</div><div>may have been removed or powered off long ago.</div><div>(yes, people don't tell us when they stop using something, or an outside vendor switches things around without IT knowing it.</div><div>I bet we all have that T-shirt..)</div><div><br></div><div>Thanks Tim</div><div><br></div><div><br></div><div><br><div><div><span class="ydpdc68a9e2yiv0529745845gmail_signature_prefix">-- </span><br><div dir="ltr" class="ydpdc68a9e2yiv0529745845gmail_signature"><div dir="ltr"><div dir="ltr"><div dir="ltr"><p><b><i><span lang="EN" style="color:blue;font-family:sans-serif;font-size:10pt;"><span style="color:blue;"><a href="https://en.wikipedia.org/wiki/Quis_custodiet_ipsos_custodes%3F" rel="nofollow" target="_blank">Quis custodiet
</a>ipsos</span></span></i></b><b><i><span style="color:blue;font-family:sans-serif;font-size:10pt;"> nexus</span></i></b><b><i><span style="color:blue;font-family: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" rel="nofollow" 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:Helvetica, Arial, sans-serif;">That’s no ordinary <strike>rabbit</strike></span> <span style="color:rgb(25,25,25);font-family: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:Helvetica, Arial, sans-serif;"> packet you ever set eyes on. </span><span style="color:rgb(25,25,25);font-family: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:Helvetica, Arial, sans-serif;font-size:18px;">.</span><span style="color:rgb(25,25,25);font-family: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: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" style="background-color: inherit;"> </font>packet on the network, isn’t it now....</span><span style="color:rgb(25,25,25);font-family:Helvetica, Arial, sans-serif;">"</span></p></div></div></div></div></div></div></div></div>
</div>_______________________________________________<br>cisco-voip mailing list<br><a href="mailto:cisco-voip@puck.nether.net" rel="nofollow" target="_blank">cisco-voip@puck.nether.net</a><br><a href="https://puck.nether.net/mailman/listinfo/cisco-voip" rel="nofollow" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br></div>
</div>
</div></body></html>