<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif;" dir="ltr">
<p style="margin-top:0;margin-bottom:0">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.</p>
<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 style="color: rgb(0, 0, 0);">
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Stephen Welsh <stephen.welsh@unifiedfx.com><br>
<b>Sent:</b> Wednesday, March 28, 2018 11:33 AM<br>
<b>To:</b> Pete Brown<br>
<b>Cc:</b> Anthony Holloway; Lelio Fulgenzi; cisco-voip@puck.nether.net<br>
<b>Subject:</b> Re: [cisco-voip] Windows AXL Query Tool</font>
<div> </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><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="" style="">
<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;
<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">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"><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">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; user-select: none;"><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>
</body>
</html>