[cisco-voip] Windows AXL Query Tool

[Anthony Holloway]

No not really.

The work flow is like this:

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
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
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++)
4. Correct the username and password, host for your environment
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)
6. Make a copy of the sample.xml file and we'll name it test.xml for this
exercise
7. Edit the test.xml so it only contains 1 query; we'll use this one for
testing: <sql query="select name from processnode"/>
8. Copy your command line from the README.txt and paste it into your
command prompt
9. Watch the activity scroll up the screen, and check your test.txt file
for the output

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.

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.

YMMV

On Wed, Mar 28, 2018 at 9:22 AM Lelio Fulgenzi <lelio at uoguelph.ca> wrote:

> Is it “wizardish” in any way? Like CUDDLI?
>
>
>
> ---
>
> *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 <(519)%20824-4120> | lelio at uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
> [image: image001.png]
>
>
>
> *From:* Anthony Holloway [mailto:avholloway+cisco-voip at gmail.com]
> *Sent:* Wednesday, March 28, 2018 10:19 AM
> *To:* Brian Meade <bmeade90 at vt.edu>
> *Cc:* Lelio Fulgenzi <lelio at uoguelph.ca>; Pete Brown <jpb at chykn.com>;
> 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> wrote:
>
> Check under Application->Plugins
>
>
>
> On Wed, Mar 28, 2018 at 10:03 AM, Lelio Fulgenzi <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 <(519)%20824-4120> | lelio at uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
> [image: University of Guelph Cornerstone with Improve Life tagline]
>
>
>
> *From:* cisco-voip [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>
> *Cc:* 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> wrote:
>
> 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
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
> _______________________________________________
> cisco-voip mailing list
> 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/07f0bf91/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 1297 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20180328/07f0bf91/attachment.png>