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-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: <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 <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 >> <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> | 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 <bmead...@vt.edu> >> *Cc:* Lelio Fulgenzi <le...@uoguelph.ca>; Pete Brown <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 <bmead...@vt.edu> wrote: >> >> Check under Application->Plugins >> >> >> >> On Wed, Mar 28, 2018 at 10:03 AM, Lelio Fulgenzi <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 >> <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> | 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 <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 <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