(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-v...@gmail.com> Sent: Wednesday, March 28, 2018 9:19 AM To: Brian Meade Cc: Lelio Fulgenzi; Pete Brown; cisco-voip@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 <bmead...@vt.edu<mailto:bmead...@vt.edu>> wrote: Check under Application->Plugins On Wed, Mar 28, 2018 at 10:03 AM, Lelio Fulgenzi <le...@uoguelph.ca<mailto:le...@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> | le...@uoguelph.ca<mailto:le...@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-boun...@puck.nether.net<mailto:cisco-voip-boun...@puck.nether.net>] On Behalf Of Anthony Holloway Sent: Tuesday, March 27, 2018 9:58 PM To: Pete Brown <j...@chykn.com<mailto:j...@chykn.com>> Cc: cisco-voip@puck.nether.net<mailto:cisco-voip@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 <j...@chykn.com<mailto:j...@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@puck.nether.net<mailto:cisco-voip@puck.nether.net> https://puck.nether.net/mailman/listinfo/cisco-voip _______________________________________________ cisco-voip mailing list cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net> https://puck.nether.net/mailman/listinfo/cisco-voip
_______________________________________________ cisco-voip mailing list cisco-voip@puck.nether.net https://puck.nether.net/mailman/listinfo/cisco-voip
