Re: [cisco-voip] Windows AXL Query Tool

[Brian Meade]

Key difference here is the GUI.  Some people like the visual reference.
I'm more a CLI guy though.

Pete, you should make a COBRAS type tool for CUCM.  Always something I wish
existed.

On Tue, Mar 27, 2018 at 9:58 PM, Anthony Holloway <
avholloway+cisco-v...@gmail.com> wrote:

> 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  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@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
>
>
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] Windows AXL Query Tool

[Lelio Fulgenzi]

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
519-824-4120 Ext. 56354 | le...@uoguelph.ca

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] On Behalf Of 
Anthony Holloway
Sent: Tuesday, March 27, 2018 9:58 PM
To: Pete Brown 
Cc: 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 
mailto:j...@chykn.com>> wrote:
[cid:8bc16a0d-4448-4067-aef0-fb4bf10e88a7]
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
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

Re: [cisco-voip] Windows AXL Query Tool

[Brian Meade]

Check under Application->Plugins

On Wed, Mar 28, 2018 at 10:03 AM, Lelio Fulgenzi  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
>
> 519-824-4120 Ext. 56354 <(519)%20824-4120> | le...@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-boun...@puck.nether.net] *On Behalf
> Of *Anthony Holloway
> *Sent:* Tuesday, March 27, 2018 9:58 PM
> *To:* Pete Brown 
> *Cc:* 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  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@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
>
>
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] Windows AXL Query Tool

[Anthony Holloway]

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  wrote:

> Check under Application->Plugins
>
> On Wed, Mar 28, 2018 at 10:03 AM, Lelio Fulgenzi 
> 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
>> 
>>
>> 519-824-4120 Ext. 56354 <(519)%20824-4120> | le...@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-boun...@puck.nether.net] *On
>> Behalf Of *Anthony Holloway
>> *Sent:* Tuesday, March 27, 2018 9:58 PM
>> *To:* Pete Brown 
>> *Cc:* 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  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@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
>>
>>
>
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] Windows AXL Query Tool

[Lelio Fulgenzi]

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
519-824-4120 Ext. 56354 | le...@uoguelph.ca

www.uoguelph.ca/ccs | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

From: Anthony Holloway [mailto:avholloway+cisco-v...@gmail.com]
Sent: Wednesday, March 28, 2018 10: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 
mailto:bmead...@vt.edu>> wrote:
Check under Application->Plugins

On Wed, Mar 28, 2018 at 10:03 AM, Lelio Fulgenzi 
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
519-824-4120 Ext. 56354 | 
le...@uoguelph.ca

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]
 On Behalf Of Anthony Holloway
Sent: Tuesday, March 27, 2018 9:58 PM
To: Pete Brown mailto:j...@chykn.com>>
Cc: 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 
mailto:j...@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@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

___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [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 
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 
mailto:bmead...@vt.edu>> wrote:
Check under Application->Plugins

On Wed, Mar 28, 2018 at 10:03 AM, Lelio Fulgenzi 
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

519-824-4120 Ext. 56354 | 
le...@uoguelph.ca



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]
 On Behalf Of Anthony Holloway
Sent: Tuesday, March 27, 2018 9:58 PM
To: Pete Brown mailto:j...@chykn.com>>
Cc: 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 
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
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


___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] Windows AXL Query Tool

[Pete Brown]

If I had the time, that sure would be a fun project!  Speaking of development 
and projects, anyone going to DevNet Create?



From: bmead...@gmail.com  on behalf of Brian Meade 

Sent: Wednesday, March 28, 2018 8:40 AM
To: Anthony Holloway
Cc: Pete Brown; cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] Windows AXL Query Tool

Key difference here is the GUI.  Some people like the visual reference.  I'm 
more a CLI guy though.

Pete, you should make a COBRAS type tool for CUCM.  Always something I wish 
existed.

On Tue, Mar 27, 2018 at 9:58 PM, Anthony Holloway 
mailto:avholloway+cisco-v...@gmail.com>> wrote:
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 
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
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


___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [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: 
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 CLIwith careful
WHERE clausesor even more commonly, I'm just looking at data with
SELECT commands.

YMMV

On Wed, Mar 28, 2018 at 9:22 AM Lelio Fulgenzi  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
> 
>
> 519-824-4120 Ext. 56354 <(519)%20824-4120> | le...@uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
> [image: image001.png]
>
>
>
> *From:* Anthony Holloway [mailto:avholloway+cisco-v...@gmail.com]
> *Sent:* Wednesday, March 28, 2018 10: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  wrote:
>
> Check under Application->Plugins
>
>
>
> On Wed, Mar 28, 2018 at 10:03 AM, Lelio Fulgenzi 
> 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
> 
>
> 519-824-4120 Ext. 56354 <(519)%20824-4120> | le...@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-boun...@puck.nether.net] *On Behalf
> Of *Anthony Holloway
> *Sent:* Tuesday, March 27, 2018 9:58 PM
> *To:* Pete Brown 
> *Cc:* 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  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@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
>
>
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] Windows AXL Query Tool

[Lelio Fulgenzi]

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
519-824-4120 Ext. 56354 | le...@uoguelph.ca

www.uoguelph.ca/ccs | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

From: Anthony Holloway [mailto:avholloway+cisco-v...@gmail.com]
Sent: Wednesday, March 28, 2018 11:46 AM
To: Lelio Fulgenzi 
Cc: Brian Meade ; Pete Brown ; 
cisco-voip@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: 
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 CLIwith careful WHERE 
clausesor even more commonly, I'm just looking at data with SELECT commands.

YMMV

On Wed, Mar 28, 2018 at 9:22 AM Lelio Fulgenzi 
mailto:le...@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
519-824-4120 Ext. 56354 | 
le...@uoguelph.ca

www.uoguelph.ca/ccs | @UofGCCS on Instagram, 
Twitter and Facebook

[image001.png]

From: Anthony Holloway 
[mailto:avholloway+cisco-v...@gmail.com]
Sent: Wednesday, March 28, 2018 10:19 AM
To: Brian Meade mailto:bmead...@vt.edu>>
Cc: Lelio Fulgenzi mailto:le...@uoguelph.ca>>; Pete Brown 
mailto:j...@chykn.com>>; 
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 
mailto:bmead...@vt.edu>> wrote:
Check under Application->Plugins

On Wed, Mar 28, 2018 at 10:03 AM, Lelio Fulgenzi 
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
519-824-4120 Ext. 56354 | 
le...@uoguelph.ca

www.uoguelph.ca/ccs | @UofGCCS on Instagram, 
Twitter and Facebook


From: cisco-voip 
[mailto:cisco-voip-boun...@puck.nether.net]
 On Behalf Of Anthony Holloway
Sent: Tuesday, March 27, 2018 9:58 PM
To: Pete Brown mailto:j...@chykn.com>>
Cc: 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 
mailto:j...@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 autom

Re: [cisco-voip] Windows AXL Query Tool

[Anthony Holloway]

Ok, now that I've downloaded it, and installed your
virus...err...appit's actually really nice!  ;)

A few quick notes:

The copy paste of the data doesn't work too well in Excel.  Specifically,
it adds a column to the left of the first column.

It would be nice to have a feature to let me find data in the tables like
CUDLI does.  E.g., I need to find a table and column where this specific
phone number is used.

It would be nice to have a feature to let me see the columns for a table,
which I see that you're doing by automatically returning the first 10 rows,
but a vertical list like the tables would be better for me.

It would be nice to be able to query CAR as well, but I know that' not
apart of the same AXL API, rather its CDROnDemand, no?

It would be nice to be able to run multiple commands at once with a line
delimiter.

It would be nice to be able to hit a keystroke to execute the command.

On Wed, Mar 28, 2018 at 10:46 AM Anthony Holloway <
avholloway+cisco-v...@gmail.com> wrote:

> 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: 
> 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 CLIwith careful
> WHERE clausesor even more commonly, I'm just looking at data with
> SELECT commands.
>
> YMMV
>
> On Wed, Mar 28, 2018 at 9:22 AM Lelio Fulgenzi  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
>> 
>>
>> 519-824-4120 Ext. 56354 <(519)%20824-4120> | le...@uoguelph.ca
>>
>>
>>
>> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>>
>>
>>
>> [image: image001.png]
>>
>>
>>
> *From:* Anthony Holloway [mailto:avholloway+cisco-v...@gmail.com]
>> *Sent:* Wednesday, March 28, 2018 10: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  wrote:
>>
>> Check under Application->Plugins
>>
>>
>>
>> On Wed, Mar 28, 2018 at 10:03 AM, Lelio Fulgenzi 
>> 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
>> 
>>
>> 519-824-4120 Ext. 56354 <(519)%20824-4120> | le...@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-boun...@puck.nether.net] *On
>> Behalf Of *Anthony Holloway
>> *Sent:* Tuesday, March 27, 2018 9:58 PM
>> *To:* Pete Brown 
>> *Cc:* 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  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.
>>
>>
>

Re: [cisco-voip] Windows AXL Query Tool

[Brian Meade]

Just to give Lelio a use case, I mostly use this now when I need to add a
BLF SD to an operator console maxed out with sidecars.

I run one script to delete all the BLFs then another to add them all back
with the new one in the correct order.

On Wed, Mar 28, 2018 at 11:46 AM, Anthony Holloway <
avholloway+cisco-v...@gmail.com> wrote:

> 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: 
> 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 CLIwith careful
> WHERE clausesor even more commonly, I'm just looking at data with
> SELECT commands.
>
> YMMV
>
> On Wed, Mar 28, 2018 at 9:22 AM Lelio Fulgenzi  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
>> 
>>
>> 519-824-4120 Ext. 56354 <(519)%20824-4120> | le...@uoguelph.ca
>>
>>
>>
>> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>>
>>
>>
>> [image: image001.png]
>>
>>
>>
>> *From:* Anthony Holloway [mailto:avholloway+cisco-v...@gmail.com]
>> *Sent:* Wednesday, March 28, 2018 10: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  wrote:
>>
>> Check under Application->Plugins
>>
>>
>>
>> On Wed, Mar 28, 2018 at 10:03 AM, Lelio Fulgenzi 
>> 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
>> 
>>
>> 519-824-4120 Ext. 56354 <(519)%20824-4120> | le...@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-boun...@puck.nether.net] *On
>> Behalf Of *Anthony Holloway
>> *Sent:* Tuesday, March 27, 2018 9:58 PM
>> *To:* Pete Brown 
>> *Cc:* 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  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
>>
>>
>>
>> _

Re: [cisco-voip] Windows AXL Query Tool

[Pete Brown]

Yeah, for some reason Windows 10 keeps flagging my apps as viruses.  Have to 
figure that one out someday.


Thanks for the feedback; those are all great suggestions.  Will knock out the 
easiest ones first: listing columns under the tables in the tree, copy/paste in 
Excel and executing on keystroke.



From: Anthony Holloway 
Sent: Wednesday, March 28, 2018 10:56 AM
To: Lelio Fulgenzi
Cc: Brian Meade; Pete Brown; cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] Windows AXL Query Tool

Ok, now that I've downloaded it, and installed your virus...err...appit's 
actually really nice!  ;)

A few quick notes:

The copy paste of the data doesn't work too well in Excel.  Specifically, it 
adds a column to the left of the first column.

It would be nice to have a feature to let me find data in the tables like CUDLI 
does.  E.g., I need to find a table and column where this specific phone number 
is used.

It would be nice to have a feature to let me see the columns for a table, which 
I see that you're doing by automatically returning the first 10 rows, but a 
vertical list like the tables would be better for me.

It would be nice to be able to query CAR as well, but I know that' not apart of 
the same AXL API, rather its CDROnDemand, no?

It would be nice to be able to run multiple commands at once with a line 
delimiter.

It would be nice to be able to hit a keystroke to execute the command.

On Wed, Mar 28, 2018 at 10:46 AM Anthony Holloway 
mailto:avholloway%2bcisco-v...@gmail.com>> 
wrote:
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: 
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 CLIwith careful WHERE 
clausesor even more commonly, I'm just looking at data with SELECT commands.

YMMV

On Wed, Mar 28, 2018 at 9:22 AM Lelio Fulgenzi 
mailto:le...@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

519-824-4120 Ext. 56354 | 
le...@uoguelph.ca



www.uoguelph.ca/ccs
 | @UofGCCS on Instagram, Twitter and Facebook



[image001.png]



From: Anthony Holloway 
[mailto:avholloway+cisco-v...@gmail.com]
Sent: Wednesday, March 28, 2018 10:19 AM
To: Brian Meade mailto:bmead...@vt.edu>>
Cc: Lelio Fulgenzi mailto:le...@uoguelph.ca>>; Pete Brown 
mailto:j...@chykn.com>>; 
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 
mailto:bmead...@vt.edu>> wrote:

Check under Application->Plugins



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

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



---

Lelio Fulgenzi, B.A. | Senior Analyst

Computing and Communications Services | Universit

Re: [cisco-voip] Windows AXL Query Tool

[Bill Talley]

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  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
> 519-824-4120 Ext. 56354 | le...@uoguelph.ca
>  
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>  
> 
>  
> From: Anthony Holloway [mailto:avholloway+cisco-v...@gmail.com] 
> Sent: Wednesday, March 28, 2018 11:46 AM
> To: Lelio Fulgenzi 
> Cc: Brian Meade ; Pete Brown ; 
> cisco-voip@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: 
> 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 CLIwith careful 
> WHERE clausesor even more commonly, I'm just looking at data with SELECT 
> commands.
>  
> YMMV
>  
> On Wed, Mar 28, 2018 at 9:22 AM Lelio Fulgenzi  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
> 519-824-4120 Ext. 56354 | le...@uoguelph.ca
>  
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>  
> 
>  
> From: Anthony Holloway [mailto:avholloway+cisco-v...@gmail.com] 
> Sent: Wednesday, March 28, 2018 10: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  wrote:
> Check under Application->Plugins
>  
> On Wed, Mar 28, 2018 at 10:03 AM, Lelio Fulgenzi  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
> 519-824-4120 Ext. 56354 | le...@uoguelph.ca
>  
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>  
>  
> From: cisco-voip [mailto:cisco-voip-boun...@puck.nether.net] On Behalf Of 
> Anthony Holloway
> Sent: Tuesday, March 27, 2018 9:58 PM
> To: Pete Brown 
> Cc: 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  wrote:
> 

Re: [cisco-voip] Windows AXL Query Tool

[Ben Amick]

Yeah it's windows smartscreen. It'll flag any app if it's not signed with a 
certificate.

Ben Amick
Unified Communications Analyst

From: cisco-voip  On Behalf Of Pete Brown
Sent: Wednesday, March 28, 2018 12:14 PM
To: Anthony Holloway ; Lelio Fulgenzi 

Cc: cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] Windows AXL Query Tool


Security Notice: This is an EXTERNAL email. Please exercise caution and DO NOT 
open attachments or click links from unknown or unexpected senders.

Yeah, for some reason Windows 10 keeps flagging my apps as viruses.  Have to 
figure that one out someday.



Thanks for the feedback; those are all great suggestions.  Will knock out the 
easiest ones first: listing columns under the tables in the tree, copy/paste in 
Excel and executing on keystroke.




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

Ok, now that I've downloaded it, and installed your virus...err...appit's 
actually really nice!  ;)

A few quick notes:

The copy paste of the data doesn't work too well in Excel.  Specifically, it 
adds a column to the left of the first column.

It would be nice to have a feature to let me find data in the tables like CUDLI 
does.  E.g., I need to find a table and column where this specific phone number 
is used.

It would be nice to have a feature to let me see the columns for a table, which 
I see that you're doing by automatically returning the first 10 rows, but a 
vertical list like the tables would be better for me.

It would be nice to be able to query CAR as well, but I know that' not apart of 
the same AXL API, rather its CDROnDemand, no?

It would be nice to be able to run multiple commands at once with a line 
delimiter.

It would be nice to be able to hit a keystroke to execute the command.

On Wed, Mar 28, 2018 at 10:46 AM Anthony Holloway 
mailto:avholloway%2bcisco-v...@gmail.com>> 
wrote:
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: 
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 CLIwith careful WHERE 
clausesor even more commonly, I'm just looking at data with SELECT commands.

YMMV

On Wed, Mar 28, 2018 at 9:22 AM Lelio Fulgenzi 
mailto:le...@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

519-824-4120 Ext. 56354 | 
le...@uoguelph.ca



www.uoguelph.ca/ccs
 | @UofGCCS on Instagram, Twitter and Facebook


[image001.png]



From: Anthony Holloway 
[mailto:avholloway+cisco-v...@gmail.com]
Sent: Wednesday, March 28, 2018 10:19 AM
To: Brian Meade mailto:bmead...@vt.edu>>
Cc: Lelio Fulgenzi mailto:le...@uoguelph.ca>>; Pete Brown 
mailto:j...@chy

Re: [cisco-voip] Windows AXL Query Tool

[Stephen Welsh]

Hi Pete,

When downloading Windows SmartScreen checks the signing certificate of the 
application (if applied), if you haven’t already it’s best to buy a code 
signing certificate and sign your exe’s etc. with it (we use signtool.exe to do 
that).

Recently we updated the code signing cert for PhoneView and initially (even 
with a valid cert) it was flagged by SmartScreen until it had been downloaded a 
few times.

Haven’t looked at your tool, but congrats for putting it out there, a simple 
way to query and export raw SQL data is sorely needed, something I was going to 
do but ended up going down a different path ;)

Thanks

Stephen Welsh
CTO
UnifiedFX

On 28 Mar 2018, at 17:14, Pete Brown mailto:j...@chykn.com>> 
wrote:

Yeah, for some reason Windows 10 keeps flagging my apps as viruses.  Have to 
figure that one out someday.

Thanks for the feedback; those are all great suggestions.  Will knock out the 
easiest ones first: listing columns under the tables in the tree, copy/paste in 
Excel and executing on keystroke.



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

Ok, now that I've downloaded it, and installed your virus...err...appit's 
actually really nice!  ;)

A few quick notes:

The copy paste of the data doesn't work too well in Excel.  Specifically, it 
adds a column to the left of the first column.

It would be nice to have a feature to let me find data in the tables like CUDLI 
does.  E.g., I need to find a table and column where this specific phone number 
is used.

It would be nice to have a feature to let me see the columns for a table, which 
I see that you're doing by automatically returning the first 10 rows, but a 
vertical list like the tables would be better for me.

It would be nice to be able to query CAR as well, but I know that' not apart of 
the same AXL API, rather its CDROnDemand, no?

It would be nice to be able to run multiple commands at once with a line 
delimiter.

It would be nice to be able to hit a keystroke to execute the command.

On Wed, Mar 28, 2018 at 10:46 AM Anthony Holloway 
mailto:avholloway%2bcisco-v...@gmail.com>> 
wrote:
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: 
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 CLIwith careful WHERE 
clausesor even more commonly, I'm just looking at data with SELECT commands.

YMMV

On Wed, Mar 28, 2018 at 9:22 AM Lelio Fulgenzi 
mailto:le...@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
519-824-4120 Ext. 56354 | 
le...@uoguelph.ca

www.uoguelph.ca/ccs
 | @UofGCCS on Instagram, Twitter and Facebook





From: Anthony Holloway 
[mailto:avholloway+c

Re: [cisco-voip] Attendant Console Advanced 12.0

[Ruben Trujillo via cisco-voip]

Hi Naresh,

I had an issue with missing menus after I first brought the Attendant Console 
Advanced server online. For me the cause was TSP didn't install correctly and 
the Telephony service on Windows Server didn't start automatically. Once I 
installed TSP (as administrator), set the Telephony service to automatic and 
rebooted the server I could see the missing menus.

Thanks,
Ruben Trujillo
IT Telecom

___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] Windows AXL Query Tool

[Anthony Holloway]

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  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  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
> 
>
> 519-824-4120 Ext. 56354 <(519)%20824-4120> | le...@uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
> 
>
>
>
> *From:* Anthony Holloway [mailto:avholloway+cisco-v...@gmail.com
> ]
>
> *Sent:* Wednesday, March 28, 2018 11:46 AM
> *To:* Lelio Fulgenzi 
> *Cc:* Brian Meade ; Pete Brown ;
> cisco-voip@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: 
>
> 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 CLIwith careful
> WHERE clausesor even more commonly, I'm just looking at data with
> SELECT commands.
>
>
>
> YMMV
>
> On Wed, Mar 28, 2018 at 9:22 AM Lelio Fulgenzi  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
> 
>
> 519-824-4120 Ext. 56354 <(519)%20824-4120> | le...@uoguelph.ca
>
>
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
> 
>
>
>
> *From:* Anthony Holloway [mailto:avholloway+cisco-v...@gmail.com]
> *Sent:* Wednesday, March 28, 2018 10: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 Publ

[cisco-voip] Automated capacity notification for CUCM/UCCX/QM?

[Ben Amick]

Does anyone know of any tools, either inside the cisco product or ELM, or low 
cost external tools, that will enable any sort of alerting for capacity 
management ahead of time? I know CUCM and CUC will both pop the alert at the 
top of the header when you exceed your licensing, and UCCX will deny logins, 
and QM will stop allowing you to enable users or will send alerts if a 
recording server is going high on capacity, but I've been asked to provide 
proactive alerting that lets us know when we have ___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] Windows AXL Query Tool

[Lelio Fulgenzi]

This might be comparing apples to oranges, but I remember when CUCM was on 
Windows (*shiver*) and we had to do some fancy CDR exporting stuff. I tell you, 
the SQL wizard was amazing. Building what you needed from pull downs etc. And 
then, you just click “scheduled” and boom.

Listen, I wouldn’t want to back to windows for anything. But I just wish there 
was tools like that.

---
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
519-824-4120 Ext. 56354 | le...@uoguelph.ca

www.uoguelph.ca/ccs | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

From: Anthony Holloway [mailto:avholloway+cisco-v...@gmail.com]
Sent: Wednesday, March 28, 2018 3:38 PM
To: Bill Talley 
Cc: Lelio Fulgenzi ; cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] Windows AXL Query Tool

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 
mailto:btal...@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 
mailto:le...@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
519-824-4120 Ext. 56354 | 
le...@uoguelph.ca

www.uoguelph.ca/ccs | @UofGCCS on Instagram, 
Twitter and Facebook



From: Anthony Holloway [mailto:avholloway+cisco-v...@gmail.com]
Sent: Wednesday, March 28, 2018 11:46 AM
To: Lelio Fulgenzi mailto:le...@uoguelph.ca>>
Cc: Brian Meade mailto:bmead...@vt.edu>>; Pete Brown 
mailto:j...@chykn.com>>; 
cisco-voip@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: 
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 CLIwi

Re: [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-v...@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  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  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
>> 
>>
>> 519-824-4120 Ext. 56354 <(519)%20824-4120> | le...@uoguelph.ca
>>
>>
>>
>> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>>
>>
>>
>> 
>>
>>
>>
>> *From:* Anthony Holloway [mailto:avholloway+cisco-v...@gmail.com
>> ]
>>
>> *Sent:* Wednesday, March 28, 2018 11:46 AM
>> *To:* Lelio Fulgenzi 
>> *Cc:* Brian Meade ; Pete Brown ;
>> cisco-voip@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: 
>>
>> 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 CLIwith careful
>> WHERE clausesor even more commonly, I'm just looking at data with
>> SELECT commands.
>>
>>
>>
>> YMMV
>>
>> On Wed, Mar 28, 2018 at 9:22 AM Lelio Fulgenzi  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
>> 
>>
>> 519-824-4120 Ext. 56354 <(519