<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;">
<div>Hi Tim,</div>
<div><br>
</div>
If I recall correctly ATA's have a basic level of CTI, mostly to see state.
<div><br>
</div>
<div>Looks like the ATA-186 running SCCP supports CTI:</div>
<div><br>
</div>
<div><a href="https://developer.cisco.com/site/jtapi/documents/cti-tapi-jtapi-supported-device-matrix/">https://developer.cisco.com/site/jtapi/documents/cti-tapi-jtapi-supported-device-matrix/</a></div>
<div><br>
</div>
<div>You could try out the JTAPI Test Tool and see if the ATA’s are in there and what info is available.</div>
<div><br>
</div>
<div><a href="https://developer.cisco.com/site/jtapi/downloads/">https://developer.cisco.com/site/jtapi/downloads/</a></div>
<div><br>
</div>
<div>I could only see docs/videos on the JTAPI Test Tool, it had not been updated in years but still works on latest UCM last time we used it. I’ve asked where the JTAPI Test tool is located, if I get a reply I’ll forward. I have a copy for UCM 11.5 that I
believe is the latest version, I believe I should be okay to forward as it was not tied to a support contract download etc.</div>
<div><br>
</div>
<div>Also, we shall be back at Cisco Live US next week, it anyone going gets the chance swing by for a chat and some swag ;)</div>
<div><br>
</div>
<div>Kind Regards</div>
<div><br>
</div>
<div>Stephen Welsh</div>
<div>Founder & CEO</div>
<div>UnifiedFX</div>
<div><img id="<image002.png@01D98E79.0ED3AA40>" src="cid:9F011D75-A933-48C7-BAD7-FE04E739DF6B" alt="image002.png" width="158.5" apple-inline="yes" class="Apple-web-attachment" style="opacity: 1;"><br>
<div><br>
<blockquote type="cite">
<div>On 2 Jun 2023, at 05:10, Carlo Calabrese <carlo_calabrese2006@yahoo.com> wrote:</div>
<br class="Apple-interchange-newline">
<div>
<div>
<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>
</div>
_______________________________________________<br>
cisco-voip mailing list<br>
cisco-voip@puck.nether.net<br>
https://puck.nether.net/mailman/listinfo/cisco-voip<br>
</div>
</blockquote>
</div>
<br>
</div>
</body>
</html>