[cisco-voip] Windows AXL Query Tool

[Bill Talley]

True but importing the WSDL file or files (I was referring to that as a
component) from the toolkit ensures you have the current schema, which is
important, especially if you're working with multiple CUCM versions.

On Wed, Mar 28, 2018 at 2:38 PM, Anthony Holloway <
avholloway+cisco-voip at gmail.com> wrote:

> I don't think this is splitting hairs, but the toolkit is just code Cisco
> is handing out that makes working with their AXL API easier.
>
> At the most basic level I'd care to explore, you could simply hand craft
> your SOAP payload, and send the HTTPS request to CUCM and never once use
> the toolkit nor WSDL.
>
> If all you're doing is using the WSDL from the toolkit, then you're
> technically not using the toolkit, rather you're using resources (the WSDL)
> that the toolkit also happens to be using.
>
> It would be great if the WSDL was available right from CUCM, so you didn't
> have to download it.
>
>
> On Wed, Mar 28, 2018 at 11:20 AM Bill Talley <btalley at gmail.com> wrote:
>
>> Lelio,
>>
>> The AXL toolkit is what the python CLI scripts I posted earlier are based
>> on.  The script imports the wsdl file from the AXL toolkit and uses it to
>> query CUCM.  The links I posted explain the setup required.
>>
>> As far as I know, all AXL/SOAP scripts or webpages regardless of
>> programming language will use the same AXL toolkit or components of it to
>> access CUCM.  Someone correct me if I’m wrong please.
>>
>> I’m cleaning up the full python script as well as working on a GUI and
>> distributable package for the script, but hopefully they will give you an
>> idea of how to get started with Python.  It can seem overwhelming at first,
>> but it’s not that bad.  As many people can probably tell from the scripts,
>> I’m not a programmer but once you pick up the basics, it’s can be quit
>> powerful even with limited experience.
>>
>> Bill
>>
>> Sent from a mobile device with very tiny touchscreen input keys. Please
>> excude my typtos.
>>
>> On Mar 28, 2018, at 10:52 AM, Lelio Fulgenzi <lelio at uoguelph.ca> wrote:
>>
>> Ok. This is a great help. I’ll have to see which is better for me (or
>> which is easier to use) – this toolkit or CLI.
>>
>>
>>
>>
>>
>>
>>
>> ---
>>
>> *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
>>
>>
>>
>> <image001.png>
>>
>>
>>
>> *From:* Anthony Holloway [mailto:avholloway+cisco-voip at gmail.com
>> <avholloway+cisco-voip at gmail.com>]
>>
>> *Sent:* Wednesday, March 28, 2018 11:46 AM
>> *To:* Lelio Fulgenzi <lelio at uoguelph.ca>
>> *Cc:* Brian Meade <bmeade90 at vt.edu>; Pete Brown <jpb at chykn.com>;
>> cisco-voip at puck.nether.net
>> *Subject:* Re: [cisco-voip] Windows AXL Query Tool
>>
>> 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
>>
>>
>>
>> <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
>>
>>
>>
>>
>>
>> *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
>>
>> _______________________________________________
>> 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/a0de20e7/attachment.html>