<div dir="ltr">RIS has a timestamp of last action, so you could help people with knowing how long something has been in that state, until they get to CUCM v12, where it's native.</div><br><div class="gmail_quote"><div dir="ltr">On Thu, Mar 29, 2018 at 12:45 PM Pete Brown <<a href="mailto:jpb@chykn.com">jpb@chykn.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">




<div dir="ltr">
<div id="m_5641600990143676927divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif" dir="ltr">
<p style="margin-top:0;margin-bottom:0">Ryan,</p>
<p style="margin-top:0;margin-bottom:0"><br>
</p>
<p style="margin-top:0;margin-bottom:0">Thanks for pointing that out.  I use it on just about every project I work on that ties to a Cisco API.  I might disagree when it comes to ease of use (having to parse output XML, etc) but it's an invaluable tool for
 anyone who wants to start getting into the weeds with SOAP calls.</p>
<p style="margin-top:0;margin-bottom:0"><br>
</p>
<p style="margin-top:0;margin-bottom:0">I'm glad you mentioned RIS.  I was debating whether or not to add a function in this app that allows for quick device state lookup.  Maybe plug in a device name and have it kick back Device Type, Registration Status,
 Registered Host and DNs.  Of course this is info you could quickly get in the CUCM portal, so I'm not sure it would be worth having it in this app.</p>
<br>
<br>
<div style="color:rgb(0,0,0)">
<hr style="display:inline-block;width:98%">
<div id="m_5641600990143676927divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Ryan Ratliff (rratliff) <<a href="mailto:rratliff@cisco.com" target="_blank">rratliff@cisco.com</a>><br>
<b>Sent:</b> Thursday, March 29, 2018 12:11 PM<br>
<b>To:</b> Pete Brown<br>
<b>Cc:</b> Stephen Welsh; <a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a></font></div></div></div></div><div dir="ltr"><div id="m_5641600990143676927divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif" dir="ltr"><div style="color:rgb(0,0,0)"><div id="m_5641600990143676927divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><br>
<b>Subject:</b> Re: [cisco-voip] Windows AXL Query Tool</font></div></div></div></div><div dir="ltr"><div id="m_5641600990143676927divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif" dir="ltr"><div style="color:rgb(0,0,0)">
<div style="word-wrap:break-word;line-break:after-white-space">I discovered SoapUI helping somebody with a TMS case earlier this week.
<div><a href="https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdeveloper.cisco.com%2Fsite%2Fsxml%2Flearn%2Fsoap-ui-tutorial%2F&data=02%7C01%7C%7Cca30d20097ed43af4d0a08d595981667%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636579402798368320&sdata=Hgz%2FhT62UbixUouBfWUNthCAN6hN1dBEmaD8cDcu7ls%3D&reserved=0" id="m_5641600990143676927LPlnk770463" target="_blank">https://developer.cisco.com/site/sxml/learn/soap-ui-tutorial/</a></div>
<div><br>
</div>
<div>It’s based off the RIS API but the utility is generic to any SOAP interface and extremely easy to use. Just point at the wsdl and you get a full-featured gui interface.</div>
<div><br>
<div>-Ryan </div>
<div><br>
<div>On Mar 29, 2018, at 10:57 AM, Pete Brown <<a href="mailto:jpb@chykn.com" id="m_5641600990143676927LPlnk189658" target="_blank">jpb@chykn.com</a>> wrote:</div>
<br class="m_5641600990143676927x_Apple-interchange-newline">
<div>
<div id="m_5641600990143676927x_divtagdefaultwrapper" dir="ltr" style="font-style:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:12pt;font-family:Calibri,Helvetica,sans-serif">
<div style="margin-top:0px;margin-bottom:0px">Thanks Ben and Stephen.  I looked at getting an app cert, but unfortunately I've blow my hobby budget for the near future.  Bought a few upgrades for my Oculus PC.  Will look into a cert again in a few
 months when the wife has calmed down.</div>
<div><br>
</div>
Someone pointed out that the tree structure for the tables & columns is almost identical to the IFX Ontape Browser and that I might merge the two.  It's a great idea, but the only problem is that you could not run normal SQL queries against backups.  I'd have
 to implement a copy of Informix's SQL language in my parsing module.  I may still merge them, but I'd have to remove the SQL query window when parsing backup data.
<div><br>
</div>
<div>As usual, thoughts and suggestions are welcome.<br>
<br>
<div>
<hr style="display:inline-block;width:939.8125px">
<div id="m_5641600990143676927x_divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt"><b>From:</b><span class="m_5641600990143676927x_Apple-converted-space"> </span>Stephen Welsh <<a href="mailto:stephen.welsh@unifiedfx.com" id="m_5641600990143676927LPlnk315717" target="_blank">stephen.welsh@unifiedfx.com</a>><br>
<b>Sent:</b><span class="m_5641600990143676927x_Apple-converted-space"> </span>Wednesday, March 28, 2018 11:33 AM<br>
<b>To:</b><span class="m_5641600990143676927x_Apple-converted-space"> </span>Pete Brown<br>
<b>Cc:</b><span class="m_5641600990143676927x_Apple-converted-space"> </span>Anthony Holloway; Lelio Fulgenzi;
<a href="mailto:cisco-voip@puck.nether.net" id="m_5641600990143676927LPlnk372936" target="_blank">
cisco-voip@puck.nether.net</a><br>
<b>Subject:</b><span class="m_5641600990143676927x_Apple-converted-space"> </span>Re: [cisco-voip] Windows AXL Query Tool</font>
<div> </div>
</div>
<div style="word-wrap:break-word;line-break:after-white-space">Hi Pete,
<div><br>
</div>
<div>When downloading Windows SmartScreen checks the signing certificate of the application (if applied), if you haven’t already it’s best to buy a code signing certificate and sign your exe’s etc. with it (we use signtool.exe to do that).</div>
<div><br>
</div>
<div>Recently we updated the code signing cert for PhoneView and initially (even with a valid cert) it was flagged by SmartScreen until it had been downloaded a few times.</div>
<div><br>
</div>
<div>Haven’t looked at your tool, but congrats for putting it out there, a simple way to query and export raw SQL data is sorely needed, something I was going to do but ended up going down a different path ;)</div>
<div><br>
</div>
<div>Thanks</div>
<div><br>
</div>
<div>Stephen Welsh</div>
<div>CTO</div>
<div>UnifiedFX</div>
<div>
<div><br>
<blockquote type="cite">
<div>On 28 Mar 2018, at 17:14, Pete Brown <<a href="mailto:jpb@chykn.com" id="m_5641600990143676927LPlnk523639" target="_blank">jpb@chykn.com</a>> wrote:</div>
<br class="m_5641600990143676927x_x_Apple-interchange-newline">
<div>
<div id="m_5641600990143676927x_x_divtagdefaultwrapper" dir="ltr" style="font-style:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:12pt;font-family:Calibri,Helvetica,sans-serif">
<div style="margin-top:0px;margin-bottom:0px">Yeah, for some reason Windows 10 keeps flagging my apps as viruses.  Have to figure that one out someday.</div>
<div style="margin-top:0px;margin-bottom:0px"><br>
</div>
<div style="margin-top:0px;margin-bottom:0px">Thanks for the feedback; those are all great suggestions.  Will knock out the easiest ones first: listing columns under the tables in the tree, copy/paste in Excel and executing on keystroke.</div>
<div style="margin-top:0px;margin-bottom:0px"><br>
</div>
<br>
<div>
<hr style="display:inline-block;width:826.125px">
<div id="m_5641600990143676927x_x_divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt"><b>From:</b><span class="m_5641600990143676927x_x_Apple-converted-space"> </span>Anthony Holloway <<a href="mailto:avholloway+cisco-voip@gmail.com" id="m_5641600990143676927LPlnk880937" target="_blank">avholloway+cisco-voip@gmail.com</a>><br>
<b>Sent:</b><span class="m_5641600990143676927x_x_Apple-converted-space"> </span>Wednesday, March 28, 2018 10:56 AM<br>
<b>To:</b><span class="m_5641600990143676927x_x_Apple-converted-space"> </span>Lelio Fulgenzi<br>
<b>Cc:</b><span class="m_5641600990143676927x_x_Apple-converted-space"> </span>Brian Meade; Pete Brown;<span class="m_5641600990143676927x_Apple-converted-space"> </span><a href="mailto:cisco-voip@puck.nether.net" id="m_5641600990143676927LPlnk546372" target="_blank">cisco-voip@puck.nether.net</a><br>
<b>Subject:</b><span class="m_5641600990143676927x_x_Apple-converted-space"> </span>Re: [cisco-voip] Windows AXL Query Tool</font>
<div> </div>
</div>
<div>
<div dir="ltr">Ok, now that I've downloaded it, and installed your virus...err...app....it's actually really nice!  ;)
<div><br>
</div>
<div>A few quick notes:</div>
<div><br>
</div>
<div>The copy paste of the data doesn't work too well in Excel.  Specifically, it adds a column to the left of the first column.</div>
<div><br>
</div>
<div>It would be nice to have a feature to let me find data in the tables like CUDLI does.  E.g., I need to find a table and column where this specific phone number is used.</div>
<div><br>
</div>
<div>It would be nice to have a feature to let me see the columns for a table, which I see that you're doing by automatically returning the first 10 rows, but a vertical list like the tables would be better for me.</div>
<div><br>
</div>
<div>It would be nice to be able to query CAR as well, but I know that' not apart of the same AXL API, rather its CDROnDemand, no?</div>
<div><br>
</div>
<div>It would be nice to be able to run multiple commands at once with a line delimiter.</div>
<div><br>
</div>
<div>It would be nice to be able to hit a keystroke to execute the command.</div>
</div>
<br>
<div class="m_5641600990143676927x_x_x_gmail_quote">
<div dir="ltr">On Wed, Mar 28, 2018 at 10:46 AM Anthony Holloway <<a href="mailto:avholloway%2Bcisco-voip@gmail.com" id="m_5641600990143676927LPlnk216875" target="_blank">avholloway+cisco-voip@gmail.com</a>> wrote:<br>
</div>
<blockquote class="m_5641600990143676927x_x_x_gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div dir="ltr">No not really.
<div><br>
</div>
<div>The work flow is like this:</div>
<div><br>
</div>
<div>1. Download the ZIP file from CUCM plugins page and extract to your PC.  It's simply called Cisco AXL Toolkit, but the file is axlsqltoolkit.zip</div>
<div>2. Open a command prompt to the working folder you extracted the files to, such that you're in the same folder as the README.txt</div>
<div>3. Open the README.txt and make a copy of the command example for your platform: windows or linux, and for me it's windows, so line 22 I will copy to the line below the example (CTRL+d in Notepad++)</div>
<div>4. Correct the username and password, host for your environment</div>
<div>5. Add the input/output file switches: -input=test.xml -output=test.txt (we'll create the test.xml in the next step, and it will create the test.txt file for you)</div>
<div>6. Make a copy of the sample.xml file and we'll name it test.xml for this exercise</div>
<div>7. Edit the test.xml so it only contains 1 query; we'll use this one for testing: <sql query="select name from processnode"/></div>
<div>8. Copy your command line from the README.txt and paste it into your command prompt</div>
<div>9. Watch the activity scroll up the screen, and check your test.txt file for the output</div>
<div><br>
</div>
<div>Be prepared: it's SOAP and it's ugly.  So, don't be expecting CSV style data formatting here.  I typically only use this tool when I need to run UPDATE commands, like lots of them, to make changes to the DB, which is few and far between.</div>
<div><br>
</div>
<div>More commonly, I'm using UPDATE commands right on the CLI....with careful WHERE clauses....or even more commonly, I'm just looking at data with SELECT commands.</div>
<div><br>
</div>
<div>YMMV</div>
<div><br>
<div class="m_5641600990143676927x_x_x_gmail_quote"></div>
</div>
</div>
<div dir="ltr">
<div>
<div class="m_5641600990143676927x_x_x_gmail_quote">
<div dir="ltr">On Wed, Mar 28, 2018 at 9:22 AM Lelio Fulgenzi <<a href="mailto:lelio@uoguelph.ca" id="m_5641600990143676927LPlnk982740" target="_blank">lelio@uoguelph.ca</a>> wrote:<br>
</div>
</div>
</div>
</div>
<div dir="ltr">
<div>
<div class="m_5641600990143676927x_x_x_gmail_quote">
<blockquote class="m_5641600990143676927x_x_x_gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div lang="EN-US">
<div class="m_5641600990143676927x_x_x_m_-414607379177668508m_4948035344843132271WordSection1">
<div style="margin-top:0px;margin-bottom:0px">Is it “wizardish” in any way? Like CUDDLI?<u></u><u></u></div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
<div dir="ltr">
<div>
<div class="m_5641600990143676927x_x_x_gmail_quote">
<blockquote class="m_5641600990143676927x_x_x_gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div lang="EN-US">
<div class="m_5641600990143676927x_x_x_m_-414607379177668508m_4948035344843132271WordSection1">
<div style="margin-top:0px;margin-bottom:0px"><u></u> <u></u></div>
<div style="margin-top:0px;margin-bottom:0px"><span style="font-family:Arial,sans-serif">---<u></u><u></u></span></div>
<div style="margin-top:0px;margin-bottom:0px"><b><span style="font-family:Arial,sans-serif">Lelio Fulgenzi, B.A.</span></b><span style="font-family:Arial,sans-serif"><span class="m_5641600990143676927x_x_Apple-converted-space"> </span>| Senior
 Analyst<u></u><u></u></span></div>
<div style="margin-top:0px;margin-bottom:0px"><span style="font-family:Arial,sans-serif;color:rgb(51,51,51)">Computing and Communications Services</span><span style="font-family:Arial,sans-serif"><span class="m_5641600990143676927x_x_Apple-converted-space"> </span>|
 University of Guelph<u></u><u></u></span></div>
<div style="margin-top:0px;margin-bottom:0px"><span style="font-family:Arial,sans-serif">Room 037 Animal Science & Nutrition Bldg |<span class="m_5641600990143676927x_x_Apple-converted-space"> </span><a href="https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fmaps.google.com%2F%3Fq%3D50%2BStone%2BRd%2BE%2B%257C%2BGuelph%2C%2BON%2B%257C%2BN1G%2B2W1%26entry%3Dgmail%26source%3Dg&data=02%7C01%7C%7C8de499903f864681d3e208d594c4737b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636578493819200177&sdata=4FzepRmFa4VVXPbW3nB2h0oaEfhGY1FILIwUSroH0b4%3D&reserved=0" id="m_5641600990143676927LPlnk91866" target="_blank">50
 Stone Rd E | Guelph, ON | N1G 2W1</a><u></u><u></u></span></div>
<div style="margin-top:0px;margin-bottom:0px"><span style="font-family:Arial,sans-serif"><a href="tel:(519)%20824-4120" value="+15198244120" id="m_5641600990143676927LPlnk570069" target="_blank">519-824-4120 Ext. 56354</a><span class="m_5641600990143676927x_x_Apple-converted-space"> </span>|<span class="m_5641600990143676927x_x_Apple-converted-space"> </span><a href="mailto:lelio@uoguelph.ca" id="m_5641600990143676927LPlnk699128" target="_blank"><span style="color:rgb(5,99,193)">lelio@uoguelph.ca</span></a><u></u><u></u></span></div>
<div style="margin-top:0px;margin-bottom:0px"><span style="font-family:Arial,sans-serif"><u></u> <u></u></span></div>
<div style="margin-top:0px;margin-bottom:0px"><a href="https://nam01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.uoguelph.ca%2Fccs&data=02%7C01%7C%7C8de499903f864681d3e208d594c4737b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636578493819200177&sdata=ZkjsfAUXWCpgBFURK94yccanpo1L6JXMecdJ%2FdzCBDw%3D&reserved=0" id="m_5641600990143676927LPlnk260928" target="_blank"><span style="font-family:Arial,sans-serif">www.uoguelph.ca/ccs</span></a><span style="font-family:Arial,sans-serif;color:rgb(31,73,125)"><span class="m_5641600990143676927x_x_Apple-converted-space"> </span>|
 @UofGCCS on Instagram, Twitter and Facebook<u></u><u></u></span></div>
<div style="margin-top:0px;margin-bottom:0px"><span style="font-family:Arial,sans-serif"><u></u> <u></u></span></div>
<p class="m_5641600990143676927x_x_x_MsoNormal" style="margin-top:0px;margin-bottom:0px"></p>
</div>
</div>
</blockquote>
</div>
</div>
</div>
<div dir="ltr">
<div>
<div class="m_5641600990143676927x_x_x_gmail_quote">
<blockquote class="m_5641600990143676927x_x_x_gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div lang="EN-US">
<div class="m_5641600990143676927x_x_x_m_-414607379177668508m_4948035344843132271WordSection1"><span id="m_5641600990143676927x_x_cid:1626d3e369b4cff311"><image001.png></span><u></u><u></u>
<p style="margin-top:0px;margin-bottom:0px"></p>
<div style="margin-top:0px;margin-bottom:0px"><u></u> <u></u></div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
<div dir="ltr">
<div>
<div class="m_5641600990143676927x_x_x_gmail_quote">
<blockquote class="m_5641600990143676927x_x_x_gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div lang="EN-US">
<div class="m_5641600990143676927x_x_x_m_-414607379177668508m_4948035344843132271WordSection1">
<div style="margin-top:0px;margin-bottom:0px"><b>From:</b><span class="m_5641600990143676927x_x_Apple-converted-space"> </span>Anthony Holloway [mailto:<a href="mailto:avholloway%2Bcisco-voip@gmail.com" id="m_5641600990143676927LPlnk584945" target="_blank">avholloway+cisco-voip@gmail.com</a>]<span class="m_5641600990143676927x_x_Apple-converted-space"> </span><br>
<b>Sent:</b><span class="m_5641600990143676927x_x_Apple-converted-space"> </span>Wednesday, March 28, 2018 10:19 AM<br>
<b>To:</b><span class="m_5641600990143676927x_x_Apple-converted-space"> </span>Brian Meade <<a href="mailto:bmeade90@vt.edu" id="m_5641600990143676927LPlnk546146" target="_blank">bmeade90@vt.edu</a>><br>
<b>Cc:</b><span class="m_5641600990143676927x_x_Apple-converted-space"> </span>Lelio Fulgenzi <<a href="mailto:lelio@uoguelph.ca" id="m_5641600990143676927LPlnk504461" target="_blank">lelio@uoguelph.ca</a>>; Pete Brown <<a href="mailto:jpb@chykn.com" id="m_5641600990143676927LPlnk214260" target="_blank">jpb@chykn.com</a>>;<span class="m_5641600990143676927x_x_Apple-converted-space"> </span><a href="mailto:cisco-voip@puck.nether.net" id="m_5641600990143676927LPlnk788594" target="_blank">cisco-voip@puck.nether.net</a></div>
</div>
</div>
<div lang="EN-US">
<div class="m_5641600990143676927x_x_x_m_-414607379177668508m_4948035344843132271WordSection1">
<div style="margin-top:0px;margin-bottom:0px"><br>
<b>Subject:</b><span class="m_5641600990143676927x_x_Apple-converted-space"> </span>Re: [cisco-voip] Windows AXL Query Tool<u></u><u></u></div>
</div>
</div>
<div lang="EN-US">
<div class="m_5641600990143676927x_x_x_m_-414607379177668508m_4948035344843132271WordSection1">
<div style="margin-top:0px;margin-bottom:0px"><u></u> <u></u></div>
<div>
<div style="margin-top:0px;margin-bottom:0px">Yeah, it's really just for batch SQL commands, otherwise, just SSHing to the Publisher is easiest.<u></u><u></u></div>
</div>
<div style="margin-top:0px;margin-bottom:0px"><u></u> <u></u></div>
</div>
</div>
<div lang="EN-US">
<div class="m_5641600990143676927x_x_x_m_-414607379177668508m_4948035344843132271WordSection1">
<div>
<div>
<div style="margin-top:0px;margin-bottom:0px">On Wed, Mar 28, 2018 at 9:16 AM Brian Meade <<a href="mailto:bmeade90@vt.edu" id="m_5641600990143676927LPlnk93738" target="_blank">bmeade90@vt.edu</a>> wrote:<u></u><u></u></div>
</div>
</div>
</div>
</div>
<div lang="EN-US">
<div class="m_5641600990143676927x_x_x_m_-414607379177668508m_4948035344843132271WordSection1">
<div>
<blockquote style="border-style:none none none solid;border-left-width:1pt;border-left-color:rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in">
<div>
<div style="margin-top:0px;margin-bottom:0px">Check under Application->Plugins<u></u><u></u></div>
</div>
<div>
<div style="margin-top:0px;margin-bottom:0px"><u></u> <u></u></div>
<div></div>
</div>
</blockquote>
</div>
</div>
</div>
<div lang="EN-US">
<div class="m_5641600990143676927x_x_x_m_-414607379177668508m_4948035344843132271WordSection1">
<div>
<blockquote style="border-style:none none none solid;border-left-width:1pt;border-left-color:rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<div style="margin-top:0px;margin-bottom:0px">On Wed, Mar 28, 2018 at 10:03 AM, Lelio Fulgenzi <<a href="mailto:lelio@uoguelph.ca" id="m_5641600990143676927LPlnk438049" target="_blank">lelio@uoguelph.ca</a>> wrote:<u></u><u></u></div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
<div lang="EN-US">
<div class="m_5641600990143676927x_x_x_m_-414607379177668508m_4948035344843132271WordSection1">
<div>
<blockquote style="border-style:none none none solid;border-left-width:1pt;border-left-color:rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<blockquote style="border-style:none none none solid;border-left-width:1pt;border-left-color:rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<div style="margin-top:0px;margin-bottom:0px">Wait. What? There’s an AXL SQL tool kit?<span class="m_5641600990143676927x_x_Apple-converted-space"> </span><u></u><u></u></div>
<div style="margin-top:0px;margin-bottom:0px"> <u></u><u></u></div>
<div style="margin-top:0px;margin-bottom:0px"><span style="font-family:Arial,sans-serif">---</span><u></u><u></u></div>
<div style="margin-top:0px;margin-bottom:0px"><b><span style="font-family:Arial,sans-serif">Lelio Fulgenzi, B.A.</span></b><span style="font-family:Arial,sans-serif"><span class="m_5641600990143676927x_x_Apple-converted-space"> </span>| Senior
 Analyst</span><u></u><u></u></div>
<div style="margin-top:0px;margin-bottom:0px"><span style="font-family:Arial,sans-serif;color:rgb(51,51,51)">Computing and Communications Services</span><span style="font-family:Arial,sans-serif"><span class="m_5641600990143676927x_x_Apple-converted-space"> </span>|
 University of Guelph</span><u></u><u></u></div>
<div style="margin-top:0px;margin-bottom:0px"><span style="font-family:Arial,sans-serif">Room 037 Animal Science & Nutrition Bldg |<span class="m_5641600990143676927x_x_Apple-converted-space"> </span><a href="https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fmaps.google.com%2F%3Fq%3D50%2BStone%2BRd%2BE%2B%257C%2BGuelph%2C%2BON%2B%257C%2BN1G%2B2W1%26entry%3Dgmail%26source%3Dg&data=02%7C01%7C%7C8de499903f864681d3e208d594c4737b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636578493819200177&sdata=4FzepRmFa4VVXPbW3nB2h0oaEfhGY1FILIwUSroH0b4%3D&reserved=0" id="m_5641600990143676927LPlnk313780" target="_blank">50
 Stone Rd E | Guelph, ON | N1G 2W1</a></span><u></u><u></u></div>
<div style="margin-top:0px;margin-bottom:0px"><span style="font-family:Arial,sans-serif"><a href="tel:(519)%20824-4120" id="m_5641600990143676927LPlnk570724" target="_blank">519-824-4120 Ext. 56354</a><span class="m_5641600990143676927x_x_Apple-converted-space"> </span>|<span class="m_5641600990143676927x_x_Apple-converted-space"> </span><a href="mailto:lelio@uoguelph.ca" id="m_5641600990143676927LPlnk11269" target="_blank"><span style="color:rgb(5,99,193)">lelio@uoguelph.ca</span></a></span><u></u><u></u></div>
<div style="margin-top:0px;margin-bottom:0px"><span style="font-family:Arial,sans-serif"> </span><u></u><u></u></div>
<div style="margin-top:0px;margin-bottom:0px"><a href="https://nam01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.uoguelph.ca%2Fccs&data=02%7C01%7C%7C8de499903f864681d3e208d594c4737b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636578493819200177&sdata=ZkjsfAUXWCpgBFURK94yccanpo1L6JXMecdJ%2FdzCBDw%3D&reserved=0" id="m_5641600990143676927LPlnk466198" target="_blank"><span style="font-family:Arial,sans-serif">www.uoguelph.ca/ccs</span></a><span style="font-family:Arial,sans-serif;color:rgb(31,73,125)"><span class="m_5641600990143676927x_x_Apple-converted-space"> </span>|
 @UofGCCS on Instagram, Twitter and Facebook</span><u></u><u></u></div>
<div style="margin-top:0px;margin-bottom:0px"><span style="font-family:Arial,sans-serif"> </span><u></u><u></u></div>
<div style="margin-top:0px;margin-bottom:0px"><img border="0" width="187" height="100" id="m_5641600990143676927x_x_x_m_-414607379177668508m_4948035344843132271m_-6213536042740920468m_-8575135186719911374Picture_x0020_1" alt="University of Guelph Cornerstone with Improve Life tagline" style="width:1.9479in;height:1.0416in"><u></u><u></u></div>
<div style="margin-top:0px;margin-bottom:0px"> <u></u><u></u></div>
<div style="margin-top:0px;margin-bottom:0px"><b>From:</b><span class="m_5641600990143676927x_x_Apple-converted-space"> </span>cisco-voip [mailto:<a href="mailto:cisco-voip-bounces@puck.nether.net" id="m_5641600990143676927LPlnk464179" target="_blank">cisco-voip-bounces@puck.nether.net</a>]<span class="m_5641600990143676927x_x_Apple-converted-space"> </span><b>On
 Behalf Of<span class="m_5641600990143676927x_x_Apple-converted-space"> </span></b>Anthony Holloway<br>
<b>Sent:</b><span class="m_5641600990143676927x_x_Apple-converted-space"> </span>Tuesday, March 27, 2018 9:58 PM<br>
<b>To:</b><span class="m_5641600990143676927x_x_Apple-converted-space"> </span>Pete Brown <<a href="mailto:jpb@chykn.com" id="m_5641600990143676927LPlnk191394" target="_blank">jpb@chykn.com</a>><br>
<b>Cc:</b><span class="m_5641600990143676927x_x_Apple-converted-space"> </span><a href="mailto:cisco-voip@puck.nether.net" id="m_5641600990143676927LPlnk989320" target="_blank">cisco-voip@puck.nether.net</a><br>
<b>Subject:</b><span class="m_5641600990143676927x_x_Apple-converted-space"> </span>Re: [cisco-voip] Windows AXL Query Tool<u></u><u></u></div>
</div>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
</div>
</div>
<div lang="EN-US">
<div class="m_5641600990143676927x_x_x_m_-414607379177668508m_4948035344843132271WordSection1">
<div>
<blockquote style="border-style:none none none solid;border-left-width:1pt;border-left-color:rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<blockquote style="border-style:none none none solid;border-left-width:1pt;border-left-color:rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<div>
<div>
<div style="margin-top:0px;margin-bottom:0px"> <u></u><u></u></div>
<div>
<div style="margin-top:0px;margin-bottom:0px">So it only does AXL SQL Queries right now?  How's this different from the AXL SQL Toolkit that's right in CUCM?<u></u><u></u></div>
</div>
<div style="margin-top:0px;margin-bottom:0px"> <u></u><u></u></div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
</div>
</div>
<div lang="EN-US">
<div class="m_5641600990143676927x_x_x_m_-414607379177668508m_4948035344843132271WordSection1">
<div>
<blockquote style="border-style:none none none solid;border-left-width:1pt;border-left-color:rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<blockquote style="border-style:none none none solid;border-left-width:1pt;border-left-color:rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<div>
<div>
<div>
<div>
<div style="margin-top:0px;margin-bottom:0px">On Tue, Mar 27, 2018 at 4:39 PM Pete Brown <<a href="mailto:jpb@chykn.com" id="m_5641600990143676927LPlnk169654" target="_blank">jpb@chykn.com</a>> wrote:<u></u><u></u></div>
</div>
<blockquote style="border-style:none none none solid;border-left-width:1pt;border-left-color:rgb(204,204,204);padding:0in 0in 0in 6pt;margin:5pt 0in 5pt 4.8pt">
<div>
<div id="m_5641600990143676927x_x_x_m_-414607379177668508m_4948035344843132271m_-6213536042740920468m_-8575135186719911374m_-4295353326629778594divtagdefaultwrapper">
<div id="m_5641600990143676927x_x_x_m_-414607379177668508m_4948035344843132271m_-6213536042740920468m_-8575135186719911374m_-4295353326629778594OWATemporaryImageDivContainer621686" style="border:1pt dashed windowtext;padding:0in;max-width:99.9000015258789%;max-height:463px;display:inline-block;overflow:hidden">
<div style="margin-top:0px;margin-bottom:0px"><u></u><u></u></div>
</div>
<div id="m_5641600990143676927x_x_x_m_-414607379177668508m_4948035344843132271m_-6213536042740920468m_-8575135186719911374m_-4295353326629778594divtagdefaultwrapper">
<div>
<div style="margin-top:0px;margin-bottom:0px"><span style="font-size:12pt">For anyone who is interested, I wrote a quick and dirty Windows app for ad-hoc AXL queries.  I couldn't find anything readily available that didn't involve scripting. 
 It only supports SELECT statements at the moment.</span><u></u><u></u></div>
</div>
<div>
<div style="margin-top:0px;margin-bottom:0px"><span style="font-size:12pt"> </span><u></u><u></u></div>
</div>
<div>
<div style="margin-top:0px;margin-bottom:0px"><span style="font-size:12pt">It's been tested with 10.5 so far and probably has bugs which will trigger the next apocalypse.  Use at your own risk.</span><u></u><u></u></div>
</div>
<div>
<div style="margin-top:0px;margin-bottom:0px"><span style="font-size:12pt"> </span><u></u><u></u></div>
</div>
<div>
<div style="margin-top:0px;margin-bottom:0px"><span style="font-size:12pt">Usage Notes:</span><u></u><u></u></div>
</div>
<div>
<div style="margin-top:0px;margin-bottom:0px"><span style="font-size:12pt"> </span><u></u><u></u></div>
</div>
<div>
<div style="margin-top:0px;margin-bottom:0px"><span style="font-size:12pt">Adding a Profile - Right click under "Hosts" and Add Server.  Validate then Submit and it will automatically save a config file in the working directory.</span><u></u><u></u></div>
</div>
<div>
<div style="margin-top:0px;margin-bottom:0px"><span style="font-size:12pt"> </span><u></u><u></u></div>
</div>
<div>
<div style="margin-top:0px;margin-bottom:0px"><span style="font-size:12pt">Listing Tables - When you select a host, it will automatically grab a list of tables.</span><u></u><u></u></div>
</div>
<div>
<div style="margin-top:0px;margin-bottom:0px"><span style="font-size:12pt"> </span><u></u><u></u></div>
</div>
<div>
<div style="margin-top:0px;margin-bottom:0px"><span style="font-size:12pt">Queries - Type in the query and execute.  It will either display results or an error code on the bottom.</span><u></u><u></u></div>
</div>
<div>
<div style="margin-top:0px;margin-bottom:0px"><span style="font-size:12pt"> </span><u></u><u></u></div>
</div>
<div>
<div style="margin-top:0px;margin-bottom:0px"><span style="font-size:12pt"> </span><u></u><u></u></div>
</div>
<div style="margin-top:0px;margin-bottom:0px"><span style="font-size:12pt"><a href="https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.adhdtech.com%2FCUCM%2520AXL%2520Query.exe&data=02%7C01%7C%7C8de499903f864681d3e208d594c4737b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636578493819200177&sdata=13vNs%2BbaiJ4qqfQkPeheMY8M51URJO85uq84isHdYJg%3D&reserved=0" id="m_5641600990143676927LPlnk400304" target="_blank">https://www.adhdtech.com/CUCM%20AXL%20Query.exe</a></span><u></u><u></u></div>
<div>
<div style="margin-top:0px;margin-bottom:0px"><span style="font-size:12pt"> </span><u></u><u></u></div>
</div>
</div>
</div>
</div>
<div style="margin-top:0px;margin-bottom:0px">_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net" id="m_5641600990143676927LPlnk379466" target="_blank">cisco-voip@puck.nether.net</a><br>
<a href="https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fpuck.nether.net%2Fmailman%2Flistinfo%2Fcisco-voip&data=02%7C01%7C%7C8de499903f864681d3e208d594c4737b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636578493819200177&sdata=T7n0XbJVApTIUjPNZahyQVo9s5iz84GcHQZryt5bt6I%3D&reserved=0" id="m_5641600990143676927LPlnk159357" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><u></u><u></u></div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
</div>
</div>
<div lang="EN-US">
<div class="m_5641600990143676927x_x_x_m_-414607379177668508m_4948035344843132271WordSection1">
<div>
<blockquote style="border-style:none none none solid;border-left-width:1pt;border-left-color:rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<blockquote style="border-style:none none none solid;border-left-width:1pt;border-left-color:rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in">
<p class="m_5641600990143676927x_x_x_MsoNormal" style="margin-top:0px;margin-bottom:12pt"><br>
_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net" id="m_5641600990143676927LPlnk756225" target="_blank">cisco-voip@puck.nether.net</a><br>
<a href="https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fpuck.nether.net%2Fmailman%2Flistinfo%2Fcisco-voip&data=02%7C01%7C%7C8de499903f864681d3e208d594c4737b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636578493819200177&sdata=T7n0XbJVApTIUjPNZahyQVo9s5iz84GcHQZryt5bt6I%3D&reserved=0" id="m_5641600990143676927LPlnk456046" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><u></u><u></u></p>
</blockquote>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
<span style="font-family:Helvetica;font-size:12px;font-style:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;float:none;display:inline!important">_______________________________________________</span><br style="font-family:Helvetica;font-size:12px;font-style:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
<span style="font-family:Helvetica;font-size:12px;font-style:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;float:none;display:inline!important">cisco-voip
 mailing list</span><br style="font-family:Helvetica;font-size:12px;font-style:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
<span style="font-family:Helvetica;font-size:12px;font-style:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;float:none;display:inline!important"><a href="mailto:cisco-voip@puck.nether.net" id="m_5641600990143676927LPlnk194581" target="_blank">cisco-voip@puck.nether.net</a></span><br style="font-family:Helvetica;font-size:12px;font-style:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
<span style="font-family:Helvetica;font-size:12px;font-style:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;float:none;display:inline!important"><a href="https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fpuck.nether.net%2Fmailman%2Flistinfo%2Fcisco-voip&data=02%7C01%7C%7Cd026ed2da4224199412b08d594c9b385%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636578516373096019&sdata=o4bM2kekZLrGYfMbHC0CbRnASYmwFWCIS%2B4BwQNbcrQ%3D&reserved=0" id="m_5641600990143676927LPlnk509672" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a></span></div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</div>
</div>
<span style="font-family:LucidaGrande;font-size:12px;font-style:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;float:none;display:inline!important">_______________________________________________</span><br style="font-family:LucidaGrande;font-size:12px;font-style:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
<span style="font-family:LucidaGrande;font-size:12px;font-style:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;float:none;display:inline!important">cisco-voip
 mailing list</span><br style="font-family:LucidaGrande;font-size:12px;font-style:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
<span style="font-family:LucidaGrande;font-size:12px;font-style:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;float:none;display:inline!important"><a href="mailto:cisco-voip@puck.nether.net" id="m_5641600990143676927LPlnk157771" target="_blank">cisco-voip@puck.nether.net</a></span><br style="font-family:LucidaGrande;font-size:12px;font-style:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
<span style="font-family:LucidaGrande;font-size:12px;font-style:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;float:none;display:inline!important"><a href="https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fpuck.nether.net%2Fmailman%2Flistinfo%2Fcisco-voip&data=02%7C01%7C%7Cca30d20097ed43af4d0a08d595981667%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636579402798368320&sdata=rmEKGRNkACouavgkrdk249ovE63%2Fv4VTZ0yMthsNf%2FE%3D&reserved=0" id="m_5641600990143676927LPlnk543879" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a></span></div>
</div>
<br>
</div>
</div>
</div></div></div>

_______________________________________________<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" rel="noreferrer" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
</blockquote></div>