<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"></p>
<p style="font-family: Calibri, Helvetica, sans-serif, serif, EmojiFont; font-size: 16px;">
(forgot to hit "reply all" when I sent this a minute ago)</p>
<p style="font-family: Calibri, Helvetica, sans-serif, serif, EmojiFont; font-size: 16px;">
<br>
</p>
<p style="font-family: Calibri, Helvetica, sans-serif, serif, EmojiFont; font-size: 16px;">
Anthony,</p>
<p style="font-family: Calibri, Helvetica, sans-serif, serif, EmojiFont; font-size: 16px;">
<br>
</p>
<p style="font-family: Calibri, Helvetica, sans-serif, serif, EmojiFont; font-size: 16px;">
You pointed out a glaring error in the name. I should have called it AXL SQL Query or something. That's why the binary is so small; I stripped out the other methods in the WSDL aside from executeSQLQuery.</p>
<p style="font-family: Calibri, Helvetica, sans-serif, serif, EmojiFont; font-size: 16px;">
<br>
</p>
<p style="font-family: Calibri, Helvetica, sans-serif, serif, EmojiFont; font-size: 16px;">
The AXL SQL Toolkit that comes with CUCM is helpful if you're a developer. Otherwise it's pretty much useless. You have to be familiar with a programming language and SOAP in order to use it (outside of SoapUI, that is). And you have to be familiar with
the data dictionary. It doesn't really provide a way to just get in and explore the tables (and data) like you can in MS SQL Studio.</p>
<div style="font-family: Calibri, Helvetica, sans-serif, serif, EmojiFont; font-size: 16px;">
<br>
</div>
<span style="font-family: Calibri, Helvetica, sans-serif, serif, EmojiFont; font-size: 16px;">That's the goal for this app. Give UC folks with no programming experience an easy way to get in and start looking at table data. Click on the server to query, click
the table name and immediately spit back the first 10 records as sample data. Once someone gets familiar with the tables, they can write their own queries.</span>
<div style="font-family: Calibri, Helvetica, sans-serif, serif, EmojiFont; font-size: 16px;">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif, serif, EmojiFont; font-size: 16px;">
And for those of us who do have a bit of programming experience, it's still nice to have a GUI tool that lets you quick browse data or run ad-hoc queries without recompiling every time. Yes, you can run it via SSH directly on the Call Manager, but copying/pasting
and reformatting results from the CLI can be a pain. Especially with large result sets.</div>
<p></p>
<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> Anthony Holloway <avholloway+cisco-voip@gmail.com><br>
<b>Sent:</b> Wednesday, March 28, 2018 9:19 AM<br>
<b>To:</b> Brian Meade<br>
<b>Cc:</b> Lelio Fulgenzi; Pete Brown; cisco-voip@puck.nether.net<br>
<b>Subject:</b> Re: [cisco-voip] Windows AXL Query Tool</font>
<div> </div>
</div>
<div>
<div dir="ltr">Yeah, it's really just for batch SQL commands, otherwise, just SSHing to the Publisher is easiest.</div>
<br>
<div class="x_gmail_quote">
<div dir="ltr">On Wed, Mar 28, 2018 at 9:16 AM Brian Meade <<a href="mailto:bmeade90@vt.edu" id="LPlnk593470" previewremoved="true">bmeade90@vt.edu</a>> wrote:<br>
</div>
<blockquote class="x_gmail_quote" style="margin:0 0 0 .8ex; border-left:1px #ccc solid; padding-left:1ex">
<div dir="ltr">Check under Application->Plugins</div>
<div class="x_gmail_extra"><br>
<div class="x_gmail_quote">On Wed, Mar 28, 2018 at 10:03 AM, Lelio Fulgenzi <span dir="ltr">
<<a href="mailto:lelio@uoguelph.ca" target="_blank" id="LPlnk436771" previewremoved="true">lelio@uoguelph.ca</a>></span> wrote:<br>
<blockquote class="x_gmail_quote" style="margin:0 0 0 .8ex; border-left:1px #ccc solid; padding-left:1ex">
<div lang="EN-US">
<div class="x_m_-6213536042740920468m_-8575135186719911374WordSection1">
<p class="x_MsoNormal">Wait. What? There’s an AXL SQL tool kit? <u></u><u></u></p>
<p class="x_MsoNormal"><u></u> <u></u></p>
<p class="x_MsoNormal"><span style="font-family:"Arial",sans-serif">---<u></u><u></u></span></p>
<p class="x_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="x_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="x_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" id="LPlnk331291" previewremoved="true">
50 Stone Rd E | Guelph, ON | N1G 2W1</a><u></u><u></u></span></p>
<p class="x_MsoNormal"><span style="font-family:"Arial",sans-serif"><a href="tel:(519)%20824-4120" value="+15198244120" target="_blank" id="LPlnk364910" previewremoved="true">519-824-4120 Ext. 56354</a> |
<a href="mailto:lelio@uoguelph.ca" target="_blank" id="LPlnk48102" previewremoved="true">
<span style="color:#0563c1">lelio@uoguelph.ca</span></a><u></u><u></u></span></p>
<p class="x_MsoNormal"><span style="font-family:"Arial",sans-serif"><u></u> <u></u></span></p>
<p class="x_MsoNormal"><a href="http://www.uoguelph.ca/ccs" target="_blank" id="LPlnk288384" previewremoved="true"><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="x_MsoNormal"><span style="font-family:"Arial",sans-serif"><u></u> <u></u></span></p>
<p class="x_MsoNormal"><img border="0" width="187" height="100" id="x_m_-6213536042740920468m_-8575135186719911374Picture_x0020_1" alt="University of Guelph Cornerstone with Improve Life tagline" style="width: 1.9479in; height: 1.0416in; user-select: none;" src="cid:image001.png@01D3C67B.F8BADFF0"><u></u><u></u></p>
<p class="x_MsoNormal"><u></u> <u></u></p>
<p class="x_MsoNormal"><b>From:</b> cisco-voip [mailto:<a href="mailto:cisco-voip-bounces@puck.nether.net" target="_blank" id="LPlnk863002" previewremoved="true">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" id="LPlnk296408" previewremoved="true">jpb@chykn.com</a>><br>
<b>Cc:</b> <a href="mailto:cisco-voip@puck.nether.net" target="_blank" id="LPlnk706938" previewremoved="true">
cisco-voip@puck.nether.net</a><br>
<b>Subject:</b> Re: [cisco-voip] Windows AXL Query Tool<u></u><u></u></p>
<div>
<div class="x_m_-6213536042740920468h5">
<p class="x_MsoNormal"><u></u> <u></u></p>
<div>
<p class="x_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="x_MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="x_MsoNormal">On Tue, Mar 27, 2018 at 4:39 PM Pete Brown <<a href="mailto:jpb@chykn.com" target="_blank" id="LPlnk336605" previewremoved="true">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-right:0in">
<div>
<div id="x_m_-6213536042740920468m_-8575135186719911374m_-4295353326629778594divtagdefaultwrapper">
<div id="x_m_-6213536042740920468m_-8575135186719911374m_-4295353326629778594OWATemporaryImageDivContainer621686" style="border:dashed windowtext 1.0pt; padding:0in 0in 0in 0in; max-width:99.9%; max-height:463px; display:inline-block; overflow:hidden">
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black"><img border="0" width="32" height="32" id="x_m_-6213536042740920468m_-8575135186719911374m_-4295353326629778594img397136" style="width: 0.3333in; height: 0.3333in; user-select: none;"><u></u><u></u></span></p>
</div>
<div id="x_m_-6213536042740920468m_-8575135186719911374m_-4295353326629778594divtagdefaultwrapper">
<div>
<p class="x_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.<u></u><u></u></span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black"><u></u> <u></u></span></p>
</div>
<div>
<p class="x_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.<u></u><u></u></span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black"><u></u> <u></u></span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black">Usage Notes:<u></u><u></u></span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black"><u></u> <u></u></span></p>
</div>
<div>
<p class="x_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.<u></u><u></u></span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black"><u></u> <u></u></span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black">Listing Tables - When you select a host, it will automatically grab a list of tables.<u></u><u></u></span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black"><u></u> <u></u></span></p>
</div>
<div>
<p class="x_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.<u></u><u></u></span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black"><u></u> <u></u></span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black"><u></u> <u></u></span></p>
</div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black"><a href="https://www.adhdtech.com/CUCM%20AXL%20Query.exe" target="_blank" id="LPlnk119841" previewremoved="true">https://www.adhdtech.com/CUCM%20AXL%20Query.exe</a>
<u></u><u></u></span></p>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black"><u></u> <u></u></span></p>
</div>
</div>
</div>
</div>
<p class="x_MsoNormal">_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net" target="_blank" id="LPlnk576150" previewremoved="true">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank" id="LPlnk570373" previewremoved="true">https://puck.nether.net/mailman/listinfo/cisco-voip</a><u></u><u></u></p>
</blockquote>
</div>
</div>
</div>
</div>
</div>
<br>
_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net" target="_blank" id="LPlnk775190" previewremoved="true">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" rel="noreferrer" target="_blank" id="LPlnk84857" previewremoved="true">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
<br>
</blockquote>
</div>
<br>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</body>
</html>