<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="gmail_quote"><div dir="ltr">On Wed, Mar 28, 2018 at 10:46 AM Anthony Holloway <<a href="mailto:avholloway%2Bcisco-voip@gmail.com">avholloway+cisco-voip@gmail.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">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="gmail_quote"></div></div></div><div dir="ltr"><div><div class="gmail_quote"><div dir="ltr">On Wed, Mar 28, 2018 at 9:22 AM Lelio Fulgenzi <<a href="mailto:lelio@uoguelph.ca" target="_blank">lelio@uoguelph.ca</a>> wrote:<br></div></div></div></div><div dir="ltr"><div><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-US" link="blue" vlink="purple">
<div class="m_-414607379177668508m_4948035344843132271WordSection1">
<p class="MsoNormal">Is it “wizardish” in any way? Like CUDDLI?<u></u><u></u></p></div></div></blockquote></div></div></div><div dir="ltr"><div><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="EN-US" link="blue" vlink="purple"><div class="m_-414607379177668508m_4948035344843132271WordSection1">
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">---<u></u><u></u></span></p>
<p class="MsoNormal"><b><span style="font-family:"Arial",sans-serif">Lelio Fulgenzi, B.A.</span></b><span style="font-family:"Arial",sans-serif"> | Senior Analyst<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#333333">Computing and Communications Services</span><span style="font-family:"Arial",sans-serif"> | University of Guelph<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">Room 037 Animal Science & Nutrition Bldg | <a href="https://maps.google.com/?q=50+Stone+Rd+E+%7C+Guelph,+ON+%7C+N1G+2W1&entry=gmail&source=g" target="_blank">50 Stone Rd E | Guelph, ON | N1G 2W1</a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"><a href="tel:(519)%20824-4120" value="+15198244120" target="_blank">519-824-4120 Ext. 56354</a> |
<a href="mailto:lelio@uoguelph.ca" target="_blank"><span style="color:#0563c1">lelio@uoguelph.ca</span></a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><a href="http://www.uoguelph.ca/ccs" target="_blank"><span style="font-family:"Arial",sans-serif">www.uoguelph.ca/ccs</span></a><span style="font-family:"Arial",sans-serif;color:#1f497d"> | @UofGCCS on Instagram, Twitter and Facebook<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"></p></div></div></blockquote></div></div></div><div dir="ltr"><div><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="EN-US" link="blue" vlink="purple"><div class="m_-414607379177668508m_4948035344843132271WordSection1"><img src="cid:1626d3e369b4cff311" alt="image001.png" style="max-width:100%"><u></u><u></u><p></p>
<p class="MsoNormal"><u></u> <u></u></p>
</div></div></blockquote></div></div></div><div dir="ltr"><div><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="EN-US" link="blue" vlink="purple"><div class="m_-414607379177668508m_4948035344843132271WordSection1"><p class="MsoNormal"><b>From:</b> Anthony Holloway [mailto:<a href="mailto:avholloway%2Bcisco-voip@gmail.com" target="_blank">avholloway+cisco-voip@gmail.com</a>]
<br>
<b>Sent:</b> Wednesday, March 28, 2018 10:19 AM<br>
<b>To:</b> Brian Meade <<a href="mailto:bmeade90@vt.edu" target="_blank">bmeade90@vt.edu</a>><br>
<b>Cc:</b> Lelio Fulgenzi <<a href="mailto:lelio@uoguelph.ca" target="_blank">lelio@uoguelph.ca</a>>; Pete Brown <<a href="mailto:jpb@chykn.com" target="_blank">jpb@chykn.com</a>>; <a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a></p></div></div><div lang="EN-US" link="blue" vlink="purple"><div class="m_-414607379177668508m_4948035344843132271WordSection1"><p class="MsoNormal"><br>
<b>Subject:</b> Re: [cisco-voip] Windows AXL Query Tool<u></u><u></u></p></div></div><div lang="EN-US" link="blue" vlink="purple"><div class="m_-414607379177668508m_4948035344843132271WordSection1">
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">Yeah, it's really just for batch SQL commands, otherwise, just SSHing to the Publisher is easiest.<u></u><u></u></p>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
</div></div><div lang="EN-US" link="blue" vlink="purple"><div class="m_-414607379177668508m_4948035344843132271WordSection1"><div>
<div>
<p class="MsoNormal">On Wed, Mar 28, 2018 at 9:16 AM Brian Meade <<a href="mailto:bmeade90@vt.edu" target="_blank">bmeade90@vt.edu</a>> wrote:<u></u><u></u></p>
</div>
</div></div></div><div lang="EN-US" link="blue" vlink="purple"><div class="m_-414607379177668508m_4948035344843132271WordSection1"><div><blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<p class="MsoNormal">Check under Application->Plugins<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
<div></div></div></blockquote></div></div></div><div lang="EN-US" link="blue" vlink="purple"><div class="m_-414607379177668508m_4948035344843132271WordSection1"><div><blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in"><div><div>
<p class="MsoNormal">On Wed, Mar 28, 2018 at 10:03 AM, Lelio Fulgenzi <<a href="mailto:lelio@uoguelph.ca" target="_blank">lelio@uoguelph.ca</a>> wrote:<u></u><u></u></p>
</div></div></blockquote></div></div></div><div lang="EN-US" link="blue" vlink="purple"><div class="m_-414607379177668508m_4948035344843132271WordSection1"><div><blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in"><div><div><blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in"><div><div>
<p class="MsoNormal">Wait. What? There’s an AXL SQL tool kit?
<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">---</span><u></u><u></u></p>
<p class="MsoNormal"><b><span style="font-family:"Arial",sans-serif">Lelio Fulgenzi, B.A.</span></b><span style="font-family:"Arial",sans-serif"> | Senior Analyst</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#333333">Computing and Communications Services</span><span style="font-family:"Arial",sans-serif"> | University of Guelph</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">Room 037 Animal Science & Nutrition Bldg |
<a href="https://maps.google.com/?q=50+Stone+Rd+E+%7C+Guelph,+ON+%7C+N1G+2W1&entry=gmail&source=g" target="_blank">
50 Stone Rd E | Guelph, ON | N1G 2W1</a></span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"><a href="tel:(519)%20824-4120" target="_blank">519-824-4120 Ext. 56354</a> |
<a href="mailto:lelio@uoguelph.ca" target="_blank"><span style="color:#0563c1">lelio@uoguelph.ca</span></a></span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"> </span><u></u><u></u></p>
<p class="MsoNormal"><a href="http://www.uoguelph.ca/ccs" target="_blank"><span style="font-family:"Arial",sans-serif">www.uoguelph.ca/ccs</span></a><span style="font-family:"Arial",sans-serif;color:#1f497d">
| @UofGCCS on Instagram, Twitter and Facebook</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"> </span><u></u><u></u></p>
<p class="MsoNormal"><img border="0" width="187" height="100" style="width:1.9479in;height:1.0416in" id="m_-414607379177668508m_4948035344843132271m_-6213536042740920468m_-8575135186719911374Picture_x0020_1" alt="University of Guelph Cornerstone with Improve Life tagline"><u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal"><b>From:</b> cisco-voip [mailto:<a href="mailto:cisco-voip-bounces@puck.nether.net" target="_blank">cisco-voip-bounces@puck.nether.net</a>]
<b>On Behalf Of </b>Anthony Holloway<br>
<b>Sent:</b> Tuesday, March 27, 2018 9:58 PM<br>
<b>To:</b> Pete Brown <<a href="mailto:jpb@chykn.com" target="_blank">jpb@chykn.com</a>><br>
<b>Cc:</b> <a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<b>Subject:</b> Re: [cisco-voip] Windows AXL Query Tool<u></u><u></u></p>
</div></div></blockquote></div></div></blockquote></div></div></div><div lang="EN-US" link="blue" vlink="purple"><div class="m_-414607379177668508m_4948035344843132271WordSection1"><div><blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in"><div><div><blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in"><div><div><div><div>
<p class="MsoNormal"> <u></u><u></u></p>
<div>
<p class="MsoNormal">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></p>
</div>
<p class="MsoNormal"> <u></u><u></u></p>
</div></div></div></div></blockquote></div></div></blockquote></div></div></div><div lang="EN-US" link="blue" vlink="purple"><div class="m_-414607379177668508m_4948035344843132271WordSection1"><div><blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in"><div><div><blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in"><div><div><div><div><div>
<div>
<p class="MsoNormal">On Tue, Mar 27, 2018 at 4:39 PM Pete Brown <<a href="mailto:jpb@chykn.com" target="_blank">jpb@chykn.com</a>> wrote:<u></u><u></u></p>
</div>
<blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt">
<div>
<div id="m_-414607379177668508m_4948035344843132271m_-6213536042740920468m_-8575135186719911374m_-4295353326629778594divtagdefaultwrapper">
<div style="border:dashed windowtext 1.0pt;padding:0in 0in 0in 0in;max-width:99.9%;max-height:463px;box-sizing:border-box;display:inline-block;overflow:hidden" id="m_-414607379177668508m_4948035344843132271m_-6213536042740920468m_-8575135186719911374m_-4295353326629778594OWATemporaryImageDivContainer621686">
<p class="MsoNormal"><u></u><u></u></p>
</div>
<div id="m_-414607379177668508m_4948035344843132271m_-6213536042740920468m_-8575135186719911374m_-4295353326629778594divtagdefaultwrapper">
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">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></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">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></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Usage Notes:</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">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></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Listing Tables - When you select a host, it will automatically grab a list of tables.</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Queries - Type in the query and execute. It will either display results or an error code on the bottom.</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"> </span><u></u><u></u></p>
</div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><a href="https://www.adhdtech.com/CUCM%20AXL%20Query.exe" target="_blank">https://www.adhdtech.com/CUCM%20AXL%20Query.exe</a>
</span><u></u><u></u></p>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"> </span><u></u><u></u></p>
</div>
</div>
</div>
</div>
<p class="MsoNormal">_______________________________________________<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" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><u></u><u></u></p>
</blockquote>
</div></div></div></div></div></blockquote></div></div></blockquote></div></div></div><div lang="EN-US" link="blue" vlink="purple"><div class="m_-414607379177668508m_4948035344843132271WordSection1"><div><blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in"><div><div><blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
_______________________________________________<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" 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>