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 < [email protected]> 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 <[email protected]> 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) <[email protected]> >> *Sent:* Thursday, March 29, 2018 12:11 PM >> *To:* Pete Brown >> *Cc:* Stephen Welsh; [email protected] >> >> *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 <[email protected]> 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 <[email protected]> >> *Sent:* Wednesday, March 28, 2018 11:33 AM >> *To:* Pete Brown >> *Cc:* Anthony Holloway; Lelio Fulgenzi; [email protected] >> *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 <[email protected]> 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 <[email protected]> >> *Sent:* Wednesday, March 28, 2018 10:56 AM >> *To:* Lelio Fulgenzi >> *Cc:* Brian Meade; Pete Brown; [email protected] >> *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 < >> [email protected]> 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 <[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://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> | [email protected] >> >> 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:[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://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> | [email protected] >> >> 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:[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 >> <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 >> [email protected] >> 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 >> [email protected] >> 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 >> [email protected] >> 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 >> [email protected] >> 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 >> [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
