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 < [email protected]> 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 <[email protected]> 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 <[email protected]> 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> | [email protected] >> >> >> >> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook >> >> >> >> <image001.png> >> >> >> >> *From:* Anthony Holloway [mailto:[email protected] >> <[email protected]>] >> >> *Sent:* Wednesday, March 28, 2018 11:46 AM >> *To:* Lelio Fulgenzi <[email protected]> >> *Cc:* Brian Meade <[email protected]>; Pete Brown <[email protected]>; >> [email protected] >> *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 <[email protected]> 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> | [email protected] >> >> >> >> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook >> >> >> >> <image001.png> >> >> >> >> *From:* Anthony Holloway [mailto:[email protected]] >> *Sent:* Wednesday, March 28, 2018 10:19 AM >> *To:* Brian Meade <[email protected]> >> *Cc:* Lelio Fulgenzi <[email protected]>; Pete Brown <[email protected]>; >> [email protected] >> >> >> *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 <[email protected]> wrote: >> >> Check under Application->Plugins >> >> >> >> On Wed, Mar 28, 2018 at 10:03 AM, Lelio Fulgenzi <[email protected]> >> 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> | [email protected] >> >> >> >> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook >> >> >> >> >> >> *From:* cisco-voip [mailto:[email protected]] *On >> Behalf Of *Anthony Holloway >> *Sent:* Tuesday, March 27, 2018 9:58 PM >> *To:* Pete Brown <[email protected]> >> *Cc:* [email protected] >> *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 <[email protected]> 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 >> [email protected] >> https://puck.nether.net/mailman/listinfo/cisco-voip >> >> >> _______________________________________________ >> cisco-voip mailing list >> [email protected] >> https://puck.nether.net/mailman/listinfo/cisco-voip >> >> _______________________________________________ >> cisco-voip mailing list >> [email protected] >> https://puck.nether.net/mailman/listinfo/cisco-voip >> >>
_______________________________________________ cisco-voip mailing list [email protected] https://puck.nether.net/mailman/listinfo/cisco-voip
