[cisco-voip] Windows AXL Query Tool

[Pete Brown]

(forgot to hit "reply all" when I sent this a minute ago)


Anthony,


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.


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.

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.

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.


________________________________
From: Anthony Holloway <avholloway+cisco-voip at gmail.com>
Sent: Wednesday, March 28, 2018 9:19 AM
To: Brian Meade
Cc: Lelio Fulgenzi; Pete Brown; cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] Windows AXL Query Tool

Yeah, it's really just for batch SQL commands, otherwise, just SSHing to the Publisher is easiest.

On Wed, Mar 28, 2018 at 9:16 AM Brian Meade <bmeade90 at vt.edu<mailto:bmeade90 at vt.edu>> wrote:
Check under Application->Plugins

On Wed, Mar 28, 2018 at 10:03 AM, Lelio Fulgenzi <lelio at uoguelph.ca<mailto:lelio at uoguelph.ca>> wrote:

Wait. What? There’s an AXL SQL tool kit?



---

Lelio Fulgenzi, B.A. | Senior Analyst

Computing and Communications Services | University of Guelph

Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1<https://maps.google.com/?q=50+Stone+Rd+E+%7C+Guelph,+ON+%7C+N1G+2W1&entry=gmail&source=g>

519-824-4120 Ext. 56354<tel:(519)%20824-4120> | lelio at uoguelph.ca<mailto:lelio at uoguelph.ca>



www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on Instagram, Twitter and Facebook



[University of Guelph Cornerstone with Improve Life tagline]



From: cisco-voip [mailto:cisco-voip-bounces at puck.nether.net<mailto:cisco-voip-bounces at puck.nether.net>] On Behalf Of Anthony Holloway
Sent: Tuesday, March 27, 2018 9:58 PM
To: Pete Brown <jpb at chykn.com<mailto:jpb at chykn.com>>
Cc: cisco-voip at puck.nether.net<mailto:cisco-voip at puck.nether.net>
Subject: Re: [cisco-voip] Windows AXL Query Tool



So it only does AXL SQL Queries right now?  How's this different from the AXL SQL Toolkit that's right in CUCM?



On Tue, Mar 27, 2018 at 4:39 PM Pete Brown <jpb at chykn.com<mailto:jpb at chykn.com>> wrote:

[X]

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.



It's been tested with 10.5 so far and probably has bugs which will trigger the next apocalypse.  Use at your own risk.



Usage Notes:



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.



Listing Tables - When you select a host, it will automatically grab a list of tables.



Queries - Type in the query and execute.  It will either display results or an error code on the bottom.





https://www.adhdtech.com/CUCM%20AXL%20Query.exe



_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net<mailto:cisco-voip at puck.nether.net>
https://puck.nether.net/mailman/listinfo/cisco-voip

_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net<mailto:cisco-voip at puck.nether.net>
https://puck.nether.net/mailman/listinfo/cisco-voip


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20180328/c363c040/attachment.html>