[cisco-voip] Windows AXL Query Tool

Thu Mar 29 17:30:23 EDT 2018

Just FYI, it's a different field in CUCM 12.  The RIS DB can only be relied
upon to see since midnight.

On Thu, Mar 29, 2018 at 1:54 PM, Anthony Holloway <
avholloway+cisco-voip at gmail.com> wrote:

> RIS has a timestamp of last action, so you could help people with knowing
> how long something has been in that state, until they get to CUCM v12,
> where it's native.
>
> On Thu, Mar 29, 2018 at 12:45 PM Pete Brown <jpb at chykn.com> wrote:
>
>> Ryan,
>>
>>
>> Thanks for pointing that out.  I use it on just about every project I
>> work on that ties to a Cisco API.  I might disagree when it comes to ease
>> of use (having to parse output XML, etc) but it's an invaluable tool for
>> anyone who wants to start getting into the weeds with SOAP calls.
>>
>>
>> I'm glad you mentioned RIS.  I was debating whether or not to add a
>> function in this app that allows for quick device state lookup.  Maybe plug
>> in a device name and have it kick back Device Type, Registration Status,
>> Registered Host and DNs.  Of course this is info you could quickly get in
>> the CUCM portal, so I'm not sure it would be worth having it in this app.
>>
>>
>> ------------------------------
>> *From:* Ryan Ratliff (rratliff) <rratliff at cisco.com>
>> *Sent:* Thursday, March 29, 2018 12:11 PM
>> *To:* Pete Brown
>> *Cc:* Stephen Welsh; cisco-voip at puck.nether.net
>>
>> *Subject:* Re: [cisco-voip] Windows AXL Query Tool
>> I discovered SoapUI helping somebody with a TMS case earlier this week.
>> https://developer.cisco.com/site/sxml/learn/soap-ui-tutorial/
>> <https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdeveloper.cisco.com%2Fsite%2Fsxml%2Flearn%2Fsoap-ui-tutorial%2F&data=02%7C01%7C%7Cca30d20097ed43af4d0a08d595981667%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636579402798368320&sdata=Hgz%2FhT62UbixUouBfWUNthCAN6hN1dBEmaD8cDcu7ls%3D&reserved=0>
>>
>> It’s based off the RIS API but the utility is generic to any SOAP
>> interface and extremely easy to use. Just point at the wsdl and you get a
>> full-featured gui interface.
>>
>> -Ryan
>>
>> On Mar 29, 2018, at 10:57 AM, Pete Brown <jpb at chykn.com> wrote:
>>
>> Thanks Ben and Stephen.  I looked at getting an app cert, but
>> unfortunately I've blow my hobby budget for the near future.  Bought a few
>> upgrades for my Oculus PC.  Will look into a cert again in a few months
>> when the wife has calmed down.
>>
>> Someone pointed out that the tree structure for the tables & columns is
>> almost identical to the IFX Ontape Browser and that I might merge the two.
>> It's a great idea, but the only problem is that you could not run normal
>> SQL queries against backups.  I'd have to implement a copy of Informix's
>> SQL language in my parsing module.  I may still merge them, but I'd have to
>> remove the SQL query window when parsing backup data.
>>
>> As usual, thoughts and suggestions are welcome.
>>
>> ------------------------------
>> *From:* Stephen Welsh <stephen.welsh at unifiedfx.com>
>> *Sent:* Wednesday, March 28, 2018 11:33 AM
>> *To:* Pete Brown
>> *Cc:* Anthony Holloway; Lelio Fulgenzi; cisco-voip at puck.nether.net
>> *Subject:* Re: [cisco-voip] Windows AXL Query Tool
>>
>> 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 <jpb at 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 <avholloway+cisco-voip at gmail.com>
>> *Sent:* Wednesday, March 28, 2018 10:56 AM
>> *To:* Lelio Fulgenzi
>> *Cc:* Brian Meade; Pete Brown; cisco-voip at puck.nether.net
>> *Subject:* Re: [cisco-voip] Windows AXL Query Tool
>>
>> Ok, now that I've downloaded it, and installed your
>> virus...err...app....it'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-voip at 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: <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://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fmaps.google.com%2F%3Fq%3D50%2BStone%2BRd%2BE%2B%257C%2BGuelph%2C%2BON%2B%257C%2BN1G%2B2W1%26entry%3Dgmail%26source%3Dg&data=02%7C01%7C%7C8de499903f864681d3e208d594c4737b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636578493819200177&sdata=4FzepRmFa4VVXPbW3nB2h0oaEfhGY1FILIwUSroH0b4%3D&reserved=0>
>> 519-824-4120 Ext. 56354 <(519)%20824-4120> | lelio at uoguelph.ca
>>
>> www.uoguelph.ca/ccs
>> <https://nam01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.uoguelph.ca%2Fccs&data=02%7C01%7C%7C8de499903f864681d3e208d594c4737b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636578493819200177&sdata=ZkjsfAUXWCpgBFURK94yccanpo1L6JXMecdJ%2FdzCBDw%3D&reserved=0>
>>  | @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://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fmaps.google.com%2F%3Fq%3D50%2BStone%2BRd%2BE%2B%257C%2BGuelph%2C%2BON%2B%257C%2BN1G%2B2W1%26entry%3Dgmail%26source%3Dg&data=02%7C01%7C%7C8de499903f864681d3e208d594c4737b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636578493819200177&sdata=4FzepRmFa4VVXPbW3nB2h0oaEfhGY1FILIwUSroH0b4%3D&reserved=0>
>> 519-824-4120 Ext. 56354 <(519)%20824-4120> | lelio at uoguelph.ca
>>
>> www.uoguelph.ca/ccs
>> <https://nam01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.uoguelph.ca%2Fccs&data=02%7C01%7C%7C8de499903f864681d3e208d594c4737b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636578493819200177&sdata=ZkjsfAUXWCpgBFURK94yccanpo1L6JXMecdJ%2FdzCBDw%3D&reserved=0>
>>  | @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
>> <https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.adhdtech.com%2FCUCM%2520AXL%2520Query.exe&data=02%7C01%7C%7C8de499903f864681d3e208d594c4737b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636578493819200177&sdata=13vNs%2BbaiJ4qqfQkPeheMY8M51URJO85uq84isHdYJg%3D&reserved=0>
>>
>> _______________________________________________
>> cisco-voip mailing list
>> cisco-voip at puck.nether.net
>> https://puck.nether.net/mailman/listinfo/cisco-voip
>> <https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fpuck.nether.net%2Fmailman%2Flistinfo%2Fcisco-voip&data=02%7C01%7C%7C8de499903f864681d3e208d594c4737b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636578493819200177&sdata=T7n0XbJVApTIUjPNZahyQVo9s5iz84GcHQZryt5bt6I%3D&reserved=0>
>>
>>
>> _______________________________________________
>> cisco-voip mailing list
>> cisco-voip at puck.nether.net
>> https://puck.nether.net/mailman/listinfo/cisco-voip
>> <https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fpuck.nether.net%2Fmailman%2Flistinfo%2Fcisco-voip&data=02%7C01%7C%7C8de499903f864681d3e208d594c4737b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636578493819200177&sdata=T7n0XbJVApTIUjPNZahyQVo9s5iz84GcHQZryt5bt6I%3D&reserved=0>
>>
>> _______________________________________________
>> cisco-voip mailing list
>> cisco-voip at puck.nether.net
>> https://puck.nether.net/mailman/listinfo/cisco-voip
>> <https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fpuck.nether.net%2Fmailman%2Flistinfo%2Fcisco-voip&data=02%7C01%7C%7Cd026ed2da4224199412b08d594c9b385%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636578516373096019&sdata=o4bM2kekZLrGYfMbHC0CbRnASYmwFWCIS%2B4BwQNbcrQ%3D&reserved=0>
>>
>>
>> _______________________________________________
>> cisco-voip mailing list
>> cisco-voip at puck.nether.net
>> https://puck.nether.net/mailman/listinfo/cisco-voip
>> <https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fpuck.nether.net%2Fmailman%2Flistinfo%2Fcisco-voip&data=02%7C01%7C%7Cca30d20097ed43af4d0a08d595981667%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636579402798368320&sdata=rmEKGRNkACouavgkrdk249ovE63%2Fv4VTZ0yMthsNf%2FE%3D&reserved=0>
>>
>> _______________________________________________
>> 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/20180329/c010041e/attachment.html>