<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">
I discovered SoapUI helping somebody with a TMS case earlier this week.
<div class=""><a href="https://developer.cisco.com/site/sxml/learn/soap-ui-tutorial/" class="">https://developer.cisco.com/site/sxml/learn/soap-ui-tutorial/</a></div>
<div class=""><br class="">
</div>
<div class="">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 class=""><br class="">
<div class="">-Ryan </div>
<div><br class="">
<div class="">On Mar 29, 2018, at 10:57 AM, Pete Brown <<a href="mailto:jpb@chykn.com" class="">jpb@chykn.com</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div id="divtagdefaultwrapper" dir="ltr" style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; font-size: 12pt; font-family: Calibri, Helvetica, sans-serif;" class="">
<div style="margin-top: 0px; margin-bottom: 0px;" class="">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 class=""><br class="">
</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 class=""><br class="">
</div>
<div class="">As usual, thoughts and suggestions are welcome.<br class="">
<br class="">
<div style="" class="">
<hr tabindex="-1" style="display: inline-block; width: 939.8125px;" class="">
<div id="divRplyFwdMsg" dir="ltr" class=""><font face="Calibri, sans-serif" style="font-size: 11pt;" class=""><b class="">From:</b><span class="Apple-converted-space"> </span>Stephen Welsh <<a href="mailto:stephen.welsh@unifiedfx.com" class="">stephen.welsh@unifiedfx.com</a>><br class="">
<b class="">Sent:</b><span class="Apple-converted-space"> </span>Wednesday, March 28, 2018 11:33 AM<br class="">
<b class="">To:</b><span class="Apple-converted-space"> </span>Pete Brown<br class="">
<b class="">Cc:</b><span class="Apple-converted-space"> </span>Anthony Holloway; Lelio Fulgenzi;
<a href="mailto:cisco-voip@puck.nether.net" class="">cisco-voip@puck.nether.net</a><br class="">
<b class="">Subject:</b><span class="Apple-converted-space"> </span>Re: [cisco-voip] Windows AXL Query Tool</font>
<div class=""> </div>
</div>
<div class="" style="word-wrap: break-word; line-break: after-white-space;">Hi Pete,
<div class=""><br class="">
</div>
<div class="">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 class=""><br class="">
</div>
<div class="">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 class=""><br class="">
</div>
<div class="">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 class=""><br class="">
</div>
<div class="">Thanks</div>
<div class=""><br class="">
</div>
<div class="">Stephen Welsh</div>
<div class="">CTO</div>
<div class="">UnifiedFX</div>
<div class="">
<div class=""><br class="">
<blockquote type="cite" class="">
<div class="">On 28 Mar 2018, at 17:14, Pete Brown <<a href="mailto:jpb@chykn.com" class="" id="LPlnk523639" previewremoved="true">jpb@chykn.com</a>> wrote:</div>
<br class="x_Apple-interchange-newline">
<div class="">
<div id="x_divtagdefaultwrapper" dir="ltr" class="" 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 class="" 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 class="" style="margin-top: 0px; margin-bottom: 0px;"><br class="">
</div>
<div class="" 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 class="" style="margin-top: 0px; margin-bottom: 0px;"><br class="">
</div>
<br class="">
<div class="">
<hr tabindex="-1" class="" style="display: inline-block; width: 826.125px;">
<div id="x_divRplyFwdMsg" dir="ltr" class=""><font face="Calibri, sans-serif" class="" style="font-size: 11pt;"><b class="">From:</b><span class="x_Apple-converted-space"> </span>Anthony Holloway <<a href="mailto:avholloway+cisco-voip@gmail.com" class="" id="LPlnk880937" previewremoved="true">avholloway+cisco-voip@gmail.com</a>><br class="">
<b class="">Sent:</b><span class="x_Apple-converted-space"> </span>Wednesday, March 28, 2018 10:56 AM<br class="">
<b class="">To:</b><span class="x_Apple-converted-space"> </span>Lelio Fulgenzi<br class="">
<b class="">Cc:</b><span class="x_Apple-converted-space"> </span>Brian Meade; Pete Brown;<span class="Apple-converted-space"> </span><a href="mailto:cisco-voip@puck.nether.net" class="" id="LPlnk546372" previewremoved="true">cisco-voip@puck.nether.net</a><br class="">
<b class="">Subject:</b><span class="x_Apple-converted-space"> </span>Re: [cisco-voip] Windows AXL Query Tool</font>
<div class=""> </div>
</div>
<div class="">
<div dir="ltr" class="">Ok, now that I've downloaded it, and installed your virus...err...app....it's actually really nice! ;)
<div class=""><br class="">
</div>
<div class="">A few quick notes:</div>
<div class=""><br class="">
</div>
<div class="">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 class=""><br class="">
</div>
<div class="">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 class=""><br class="">
</div>
<div class="">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 class=""><br class="">
</div>
<div class="">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 class=""><br class="">
</div>
<div class="">It would be nice to be able to run multiple commands at once with a line delimiter.</div>
<div class=""><br class="">
</div>
<div class="">It would be nice to be able to hit a keystroke to execute the command.</div>
</div>
<br class="">
<div class="x_x_gmail_quote">
<div dir="ltr" class="">On Wed, Mar 28, 2018 at 10:46 AM Anthony Holloway <<a href="mailto:avholloway%2Bcisco-voip@gmail.com" id="LPlnk216875" class="" previewremoved="true">avholloway+cisco-voip@gmail.com</a>> wrote:<br class="">
</div>
<blockquote class="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" class="">No not really.
<div class=""><br class="">
</div>
<div class="">The work flow is like this:</div>
<div class=""><br class="">
</div>
<div class="">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 class="">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 class="">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 class="">4. Correct the username and password, host for your environment</div>
<div class="">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 class="">6. Make a copy of the sample.xml file and we'll name it test.xml for this exercise</div>
<div class="">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 class="">8. Copy your command line from the README.txt and paste it into your command prompt</div>
<div class="">9. Watch the activity scroll up the screen, and check your test.txt file for the output</div>
<div class=""><br class="">
</div>
<div class="">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 class=""><br class="">
</div>
<div class="">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 class=""><br class="">
</div>
<div class="">YMMV</div>
<div class=""><br class="">
<div class="x_x_gmail_quote"></div>
</div>
</div>
<div dir="ltr" class="">
<div class="">
<div class="x_x_gmail_quote">
<div dir="ltr" class="">On Wed, Mar 28, 2018 at 9:22 AM Lelio Fulgenzi <<a href="mailto:lelio@uoguelph.ca" target="_blank" id="LPlnk982740" class="" previewremoved="true">lelio@uoguelph.ca</a>> wrote:<br class="">
</div>
</div>
</div>
</div>
<div dir="ltr" class="">
<div class="">
<div class="x_x_gmail_quote">
<blockquote class="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" class="">
<div class="x_x_m_-414607379177668508m_4948035344843132271WordSection1">
<div class="" style="margin-top: 0px; margin-bottom: 0px;">Is it “wizardish” in any way? Like CUDDLI?<u class=""></u><u class=""></u></div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
<div dir="ltr" class="">
<div class="">
<div class="x_x_gmail_quote">
<blockquote class="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" class="">
<div class="x_x_m_-414607379177668508m_4948035344843132271WordSection1">
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><u class=""></u> <u class=""></u></div>
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><span class="" style="font-family: Arial, sans-serif;">---<u class=""></u><u class=""></u></span></div>
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><b class=""><span class="" style="font-family: Arial, sans-serif;">Lelio Fulgenzi, B.A.</span></b><span class="" style="font-family: Arial, sans-serif;"><span class="x_Apple-converted-space"> </span>|
Senior Analyst<u class=""></u><u class=""></u></span></div>
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><span class="" style="font-family: Arial, sans-serif; color: rgb(51, 51, 51);">Computing and Communications Services</span><span class="" style="font-family: Arial, sans-serif;"><span class="x_Apple-converted-space"> </span>|
University of Guelph<u class=""></u><u class=""></u></span></div>
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><span class="" style="font-family: Arial, sans-serif;">Room 037 Animal Science & Nutrition Bldg |<span class="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" originalsrc="https://maps.google.com/?q=50+Stone+Rd+E+%7C+Guelph,+ON+%7C+N1G+2W1&entry=gmail&source=g" shash="IOjnPifmvdtKGy2ZG4N7s3LETS7qfJzZVKLBmRqhK7elJ+cVLG9B1HPYdb4A2ku9hMTv0tA4uj7zNUjLaKkvmHeLkUSQRcczxziq7vhb9Y4kXyarleUeH6ihi4LRffctkt7dB8e508+M+0iYe/EA0snK4gGRjbvw5ze+7yD3InY=" target="_blank" id="LPlnk723336" previewremoved="true" class="">50
Stone Rd E | Guelph, ON | N1G 2W1</a><u class=""></u><u class=""></u></span></div>
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><span class="" style="font-family: Arial, sans-serif;"><a href="tel:(519)%20824-4120" value="+15198244120" target="_blank" id="LPlnk570069" class="" previewremoved="true">519-824-4120 Ext. 56354</a><span class="x_Apple-converted-space"> </span>|<span class="x_Apple-converted-space"> </span><a href="mailto:lelio@uoguelph.ca" target="_blank" id="LPlnk699128" class="" previewremoved="true"><span class="" style="color: rgb(5, 99, 193);">lelio@uoguelph.ca</span></a><u class=""></u><u class=""></u></span></div>
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><span class="" style="font-family: Arial, sans-serif;"><u class=""></u> <u class=""></u></span></div>
<div class="" 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" originalsrc="http://www.uoguelph.ca/ccs" shash="WjYzGz3NoiL8pu/JARHb5NUa/15xVnDv8Fbi9Dy+UUcgGZjb/CZJuAULCA+uQ10mACjxCuy9KU9TznO60kkZcPTub+kfWbe79Tz+Zd7jXa+lWs1SnHPShKwl17W5ZPBFXMueusu1ZdTVVTrGWS1lW4SgBPYwyMJPsM/s26D+RZE=" target="_blank" id="LPlnk260928" class="" previewremoved="true"><span class="" style="font-family: Arial, sans-serif;">www.uoguelph.ca/ccs</span></a><span class="" style="font-family: Arial, sans-serif; color: rgb(31, 73, 125);"><span class="x_Apple-converted-space"> </span>|
@UofGCCS on Instagram, Twitter and Facebook<u class=""></u><u class=""></u></span></div>
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><span class="" style="font-family: Arial, sans-serif;"><u class=""></u> <u class=""></u></span></div>
<p class="x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;"></p>
</div>
</div>
</blockquote>
</div>
</div>
</div>
<div dir="ltr" class="">
<div class="">
<div class="x_x_gmail_quote">
<blockquote class="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" class="">
<div class="x_x_m_-414607379177668508m_4948035344843132271WordSection1"><span id="x_cid:1626d3e369b4cff311" class=""><image001.png></span><u class=""></u><u class=""></u>
<p class="" style="margin-top: 0px; margin-bottom: 0px;"></p>
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><u class=""></u> <u class=""></u></div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
<div dir="ltr" class="">
<div class="">
<div class="x_x_gmail_quote">
<blockquote class="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" class="">
<div class="x_x_m_-414607379177668508m_4948035344843132271WordSection1">
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><b class="">From:</b><span class="x_Apple-converted-space"> </span>Anthony Holloway [mailto:<a href="mailto:avholloway%2Bcisco-voip@gmail.com" target="_blank" id="LPlnk584945" class="" previewremoved="true">avholloway+cisco-voip@gmail.com</a>]<span class="x_Apple-converted-space"> </span><br class="">
<b class="">Sent:</b><span class="x_Apple-converted-space"> </span>Wednesday, March 28, 2018 10:19 AM<br class="">
<b class="">To:</b><span class="x_Apple-converted-space"> </span>Brian Meade <<a href="mailto:bmeade90@vt.edu" target="_blank" id="LPlnk546146" class="" previewremoved="true">bmeade90@vt.edu</a>><br class="">
<b class="">Cc:</b><span class="x_Apple-converted-space"> </span>Lelio Fulgenzi <<a href="mailto:lelio@uoguelph.ca" target="_blank" id="LPlnk504461" class="" previewremoved="true">lelio@uoguelph.ca</a>>; Pete Brown <<a href="mailto:jpb@chykn.com" target="_blank" id="LPlnk214260" class="" previewremoved="true">jpb@chykn.com</a>>;<span class="x_Apple-converted-space"> </span><a href="mailto:cisco-voip@puck.nether.net" target="_blank" id="LPlnk788594" class="" previewremoved="true">cisco-voip@puck.nether.net</a></div>
</div>
</div>
<div lang="EN-US" class="">
<div class="x_x_m_-414607379177668508m_4948035344843132271WordSection1">
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><br class="">
<b class="">Subject:</b><span class="x_Apple-converted-space"> </span>Re: [cisco-voip] Windows AXL Query Tool<u class=""></u><u class=""></u></div>
</div>
</div>
<div lang="EN-US" class="">
<div class="x_x_m_-414607379177668508m_4948035344843132271WordSection1">
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><u class=""></u> <u class=""></u></div>
<div class="">
<div class="" 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 class=""></u><u class=""></u></div>
</div>
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><u class=""></u> <u class=""></u></div>
</div>
</div>
<div lang="EN-US" class="">
<div class="x_x_m_-414607379177668508m_4948035344843132271WordSection1">
<div class="">
<div class="">
<div class="" style="margin-top: 0px; margin-bottom: 0px;">On Wed, Mar 28, 2018 at 9:16 AM Brian Meade <<a href="mailto:bmeade90@vt.edu" target="_blank" id="LPlnk93738" class="" previewremoved="true">bmeade90@vt.edu</a>> wrote:<u class=""></u><u class=""></u></div>
</div>
</div>
</div>
</div>
<div lang="EN-US" class="">
<div class="x_x_m_-414607379177668508m_4948035344843132271WordSection1">
<div class="">
<blockquote class="" 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 class="">
<div class="" style="margin-top: 0px; margin-bottom: 0px;">Check under Application->Plugins<u class=""></u><u class=""></u></div>
</div>
<div class="">
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><u class=""></u> <u class=""></u></div>
<div class=""></div>
</div>
</blockquote>
</div>
</div>
</div>
<div lang="EN-US" class="">
<div class="x_x_m_-414607379177668508m_4948035344843132271WordSection1">
<div class="">
<blockquote class="" 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 class="">
<div class="">
<div class="" style="margin-top: 0px; margin-bottom: 0px;">On Wed, Mar 28, 2018 at 10:03 AM, Lelio Fulgenzi <<a href="mailto:lelio@uoguelph.ca" target="_blank" id="LPlnk438049" class="" previewremoved="true">lelio@uoguelph.ca</a>> wrote:<u class=""></u><u class=""></u></div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
<div lang="EN-US" class="">
<div class="x_x_m_-414607379177668508m_4948035344843132271WordSection1">
<div class="">
<blockquote class="" 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 class="">
<div class="">
<blockquote class="" 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 class="">
<div class="">
<div class="" style="margin-top: 0px; margin-bottom: 0px;">Wait. What? There’s an AXL SQL tool kit?<span class="x_Apple-converted-space"> </span><u class=""></u><u class=""></u></div>
<div class="" style="margin-top: 0px; margin-bottom: 0px;"> <u class=""></u><u class=""></u></div>
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><span class="" style="font-family: Arial, sans-serif;">---</span><u class=""></u><u class=""></u></div>
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><b class=""><span class="" style="font-family: Arial, sans-serif;">Lelio Fulgenzi, B.A.</span></b><span class="" style="font-family: Arial, sans-serif;"><span class="x_Apple-converted-space"> </span>|
Senior Analyst</span><u class=""></u><u class=""></u></div>
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><span class="" style="font-family: Arial, sans-serif; color: rgb(51, 51, 51);">Computing and Communications Services</span><span class="" style="font-family: Arial, sans-serif;"><span class="x_Apple-converted-space"> </span>|
University of Guelph</span><u class=""></u><u class=""></u></div>
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><span class="" style="font-family: Arial, sans-serif;">Room 037 Animal Science & Nutrition Bldg |<span class="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" originalsrc="https://maps.google.com/?q=50+Stone+Rd+E+%7C+Guelph,+ON+%7C+N1G+2W1&entry=gmail&source=g" shash="IOjnPifmvdtKGy2ZG4N7s3LETS7qfJzZVKLBmRqhK7elJ+cVLG9B1HPYdb4A2ku9hMTv0tA4uj7zNUjLaKkvmHeLkUSQRcczxziq7vhb9Y4kXyarleUeH6ihi4LRffctkt7dB8e508+M+0iYe/EA0snK4gGRjbvw5ze+7yD3InY=" target="_blank" id="LPlnk999479" previewremoved="true" class="">50
Stone Rd E | Guelph, ON | N1G 2W1</a></span><u class=""></u><u class=""></u></div>
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><span class="" style="font-family: Arial, sans-serif;"><a href="tel:(519)%20824-4120" target="_blank" id="LPlnk570724" class="" previewremoved="true">519-824-4120 Ext. 56354</a><span class="x_Apple-converted-space"> </span>|<span class="x_Apple-converted-space"> </span><a href="mailto:lelio@uoguelph.ca" target="_blank" id="LPlnk11269" class="" previewremoved="true"><span class="" style="color: rgb(5, 99, 193);">lelio@uoguelph.ca</span></a></span><u class=""></u><u class=""></u></div>
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><span class="" style="font-family: Arial, sans-serif;"> </span><u class=""></u><u class=""></u></div>
<div class="" 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" originalsrc="http://www.uoguelph.ca/ccs" shash="WjYzGz3NoiL8pu/JARHb5NUa/15xVnDv8Fbi9Dy+UUcgGZjb/CZJuAULCA+uQ10mACjxCuy9KU9TznO60kkZcPTub+kfWbe79Tz+Zd7jXa+lWs1SnHPShKwl17W5ZPBFXMueusu1ZdTVVTrGWS1lW4SgBPYwyMJPsM/s26D+RZE=" target="_blank" id="LPlnk466198" class="" previewremoved="true"><span class="" style="font-family: Arial, sans-serif;">www.uoguelph.ca/ccs</span></a><span class="" style="font-family: Arial, sans-serif; color: rgb(31, 73, 125);"><span class="x_Apple-converted-space"> </span>|
@UofGCCS on Instagram, Twitter and Facebook</span><u class=""></u><u class=""></u></div>
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><span class="" style="font-family: Arial, sans-serif;"> </span><u class=""></u><u class=""></u></div>
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><img border="0" width="187" height="100" id="x_x_m_-414607379177668508m_4948035344843132271m_-6213536042740920468m_-8575135186719911374Picture_x0020_1" alt="University of Guelph Cornerstone with Improve Life tagline" class="" style="width: 1.9479in; height: 1.0416in;"><u class=""></u><u class=""></u></div>
<div class="" style="margin-top: 0px; margin-bottom: 0px;"> <u class=""></u><u class=""></u></div>
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><b class="">From:</b><span class="x_Apple-converted-space"> </span>cisco-voip [mailto:<a href="mailto:cisco-voip-bounces@puck.nether.net" target="_blank" id="LPlnk464179" class="" previewremoved="true">cisco-voip-bounces@puck.nether.net</a>]<span class="x_Apple-converted-space"> </span><b class="">On
Behalf Of<span class="x_Apple-converted-space"> </span></b>Anthony Holloway<br class="">
<b class="">Sent:</b><span class="x_Apple-converted-space"> </span>Tuesday, March 27, 2018 9:58 PM<br class="">
<b class="">To:</b><span class="x_Apple-converted-space"> </span>Pete Brown <<a href="mailto:jpb@chykn.com" target="_blank" id="LPlnk191394" class="" previewremoved="true">jpb@chykn.com</a>><br class="">
<b class="">Cc:</b><span class="x_Apple-converted-space"> </span><a href="mailto:cisco-voip@puck.nether.net" target="_blank" id="LPlnk989320" class="" previewremoved="true">cisco-voip@puck.nether.net</a><br class="">
<b class="">Subject:</b><span class="x_Apple-converted-space"> </span>Re: [cisco-voip] Windows AXL Query Tool<u class=""></u><u class=""></u></div>
</div>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
</div>
</div>
<div lang="EN-US" class="">
<div class="x_x_m_-414607379177668508m_4948035344843132271WordSection1">
<div class="">
<blockquote class="" 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 class="">
<div class="">
<blockquote class="" 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 class="">
<div class="">
<div class="">
<div class="">
<div class="" style="margin-top: 0px; margin-bottom: 0px;"> <u class=""></u><u class=""></u></div>
<div class="">
<div class="" 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 class=""></u><u class=""></u></div>
</div>
<div class="" style="margin-top: 0px; margin-bottom: 0px;"> <u class=""></u><u class=""></u></div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
</div>
</div>
<div lang="EN-US" class="">
<div class="x_x_m_-414607379177668508m_4948035344843132271WordSection1">
<div class="">
<blockquote class="" 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 class="">
<div class="">
<blockquote class="" 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 class="">
<div class="">
<div class="">
<div class="">
<div class="">
<div class="">
<div class="" style="margin-top: 0px; margin-bottom: 0px;">On Tue, Mar 27, 2018 at 4:39 PM Pete Brown <<a href="mailto:jpb@chykn.com" target="_blank" id="LPlnk169654" class="" previewremoved="true">jpb@chykn.com</a>> wrote:<u class=""></u><u class=""></u></div>
</div>
<blockquote class="" 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 class="">
<div id="x_x_m_-414607379177668508m_4948035344843132271m_-6213536042740920468m_-8575135186719911374m_-4295353326629778594divtagdefaultwrapper" class="">
<div id="x_x_m_-414607379177668508m_4948035344843132271m_-6213536042740920468m_-8575135186719911374m_-4295353326629778594OWATemporaryImageDivContainer621686" class="" style="border: 1pt dashed windowtext; padding: 0in; max-width: 99.9000015258789%; max-height: 463px; display: inline-block; overflow: hidden;">
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><u class=""></u><u class=""></u></div>
</div>
<div id="x_x_m_-414607379177668508m_4948035344843132271m_-6213536042740920468m_-8575135186719911374m_-4295353326629778594divtagdefaultwrapper" class="">
<div class="">
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><span class="" 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 class=""></u><u class=""></u></div>
</div>
<div class="">
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><span class="" style="font-size: 12pt;"> </span><u class=""></u><u class=""></u></div>
</div>
<div class="">
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><span class="" 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 class=""></u><u class=""></u></div>
</div>
<div class="">
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><span class="" style="font-size: 12pt;"> </span><u class=""></u><u class=""></u></div>
</div>
<div class="">
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><span class="" style="font-size: 12pt;">Usage Notes:</span><u class=""></u><u class=""></u></div>
</div>
<div class="">
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><span class="" style="font-size: 12pt;"> </span><u class=""></u><u class=""></u></div>
</div>
<div class="">
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><span class="" 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 class=""></u><u class=""></u></div>
</div>
<div class="">
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><span class="" style="font-size: 12pt;"> </span><u class=""></u><u class=""></u></div>
</div>
<div class="">
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><span class="" style="font-size: 12pt;">Listing Tables - When you select a host, it will automatically grab a list of tables.</span><u class=""></u><u class=""></u></div>
</div>
<div class="">
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><span class="" style="font-size: 12pt;"> </span><u class=""></u><u class=""></u></div>
</div>
<div class="">
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><span class="" 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 class=""></u><u class=""></u></div>
</div>
<div class="">
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><span class="" style="font-size: 12pt;"> </span><u class=""></u><u class=""></u></div>
</div>
<div class="">
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><span class="" style="font-size: 12pt;"> </span><u class=""></u><u class=""></u></div>
</div>
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><span class="" 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" originalsrc="https://www.adhdtech.com/CUCM%20AXL%20Query.exe" shash="lCfxNM5CWzBcVIWE2dWDW/Dl97y4cqLQZ9n/GjYbiRMBeeSz0vjLHxyGMSgU/JZogVP/JM3aSx0bHRW/o+bm86rqDelakO30iwffSAA3/CFh3L1xxPuLNvDsFm3M5bjcLLONAt8uHl1znDWy4m2p08ygH0R77geRh5uNI9kk52w=" target="_blank" id="LPlnk400304" class="" previewremoved="true">https://www.adhdtech.com/CUCM%20AXL%20Query.exe</a></span><u class=""></u><u class=""></u></div>
<div class="">
<div class="" style="margin-top: 0px; margin-bottom: 0px;"><span class="" style="font-size: 12pt;"> </span><u class=""></u><u class=""></u></div>
</div>
</div>
</div>
</div>
<div class="" style="margin-top: 0px; margin-bottom: 0px;">_______________________________________________<br class="">
cisco-voip mailing list<br class="">
<a href="mailto:cisco-voip@puck.nether.net" target="_blank" id="LPlnk379466" class="" previewremoved="true">cisco-voip@puck.nether.net</a><br class="">
<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" originalsrc="https://puck.nether.net/mailman/listinfo/cisco-voip" shash="nht1GBiDSeljret5xas8yWZZI8EruiwCtCCBB75gQ0q+d51fySNgoxI/ik9i9nfyLXVbS2m64/K4FZ/8sZ53z1Nxiqv5iaz9O8UioZpQui2l3aX/KMZf0lWpefcjaebEeIFzSOtD7X+P54OUqGr+d9oer8Nt0V6RVdLTUD+tj1s=" target="_blank" id="LPlnk159357" class="" previewremoved="true">https://puck.nether.net/mailman/listinfo/cisco-voip</a><u class=""></u><u class=""></u></div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
</div>
</div>
<div lang="EN-US" class="">
<div class="x_x_m_-414607379177668508m_4948035344843132271WordSection1">
<div class="">
<blockquote class="" 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 class="">
<div class="">
<blockquote class="" 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="x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 12pt;"><br class="">
_______________________________________________<br class="">
cisco-voip mailing list<br class="">
<a href="mailto:cisco-voip@puck.nether.net" target="_blank" id="LPlnk756225" class="" previewremoved="true">cisco-voip@puck.nether.net</a><br class="">
<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" originalsrc="https://puck.nether.net/mailman/listinfo/cisco-voip" shash="nht1GBiDSeljret5xas8yWZZI8EruiwCtCCBB75gQ0q+d51fySNgoxI/ik9i9nfyLXVbS2m64/K4FZ/8sZ53z1Nxiqv5iaz9O8UioZpQui2l3aX/KMZf0lWpefcjaebEeIFzSOtD7X+P54OUqGr+d9oer8Nt0V6RVdLTUD+tj1s=" target="_blank" id="LPlnk456046" class="" previewremoved="true">https://puck.nether.net/mailman/listinfo/cisco-voip</a><u class=""></u><u class=""></u></p>
</blockquote>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
<span class="" 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 class="" 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 class="" 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 class="" 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 class="" 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" class="" id="LPlnk194581" previewremoved="true">cisco-voip@puck.nether.net</a></span><br class="" 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 class="" 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" originalsrc="https://puck.nether.net/mailman/listinfo/cisco-voip" shash="Ymi0225vDlXbB7TRrEQlCOmImKMFiCOVrdrSR5x6fzwYqoKsnVmwTKjmY55c3LxRA86nKAyP3RakW/ng/QO/9m8iinIVBLug1q3Moq7jMUT1qbg0Yjk/3JBS8Qpxjx74PnWFrfl2i0J1l3WB3+Yjcmbrt6DkholT6TlHYeVdPTU=" class="" id="LPlnk509672" previewremoved="true">https://puck.nether.net/mailman/listinfo/cisco-voip</a></span></div>
</blockquote>
</div>
<br class="">
</div>
</div>
</div>
</div>
</div>
<span style="font-family: LucidaGrande; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">_______________________________________________</span><br style="font-family: LucidaGrande; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<span style="font-family: LucidaGrande; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">cisco-voip
mailing list</span><br style="font-family: LucidaGrande; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<span style="font-family: LucidaGrande; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class=""><a href="mailto:cisco-voip@puck.nether.net" class="">cisco-voip@puck.nether.net</a></span><br style="font-family: LucidaGrande; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<span style="font-family: LucidaGrande; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class=""><a href="https://puck.nether.net/mailman/listinfo/cisco-voip" class="">https://puck.nether.net/mailman/listinfo/cisco-voip</a></span></div>
</div>
<br class="">
</div>
</body>
</html>