<div dir="ltr"><div><div><div>10.6 would also give you alot of the information you want via the XML provisioning API. Took a quick look on a box here and you'd dump the current application list (including the script name) via '<a href="https://x.x.x.x/adminapi/application">https://x.x.x.x/adminapi/application</a>' and triggers via '<a href="https://x.x.x.x/adminapi/trigger">https://x.x.x.x/adminapi/trigger</a>'. The XML dumped from the trigger page includes the application name, and the XML dumped from the application page will include the script name. You'll still have to tie the two together but you can use the application name as the key.<br><br></div><div>Can hit those urls via browser just fine. You'll just be prompted for auth (login as an administrator).<br></div><div><br></div>The adminapi has gotten alot better since 9 and the docs on devnet should give you a full rundown on what can be accessed these days.<br><br></div>HTH<br><br></div>Nathan<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Jun 22, 2016 at 12:46 AM, Anthony Holloway <span dir="ltr"><<a href="mailto:avholloway+cisco-voip@gmail.com" target="_blank">avholloway+cisco-voip@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>Unfortunately the DB schema is such that the script name is inside of this long ugly BLOB column called PrivateData, and it screws up the output display in PuTTy.</div><div><br></div><div>You can see the script name, but it's not very nice. So, if you're willing to deal with it, then here you go:</div><div><br></div><div><font face="monospace, monospace">run uccx sql db_cra select applicationname, privatedata from crsapplication where active = 't'</font><br></div><div><br></div><div>Then, to get the Triggers in the same query would be even more of an ugly mess of output, but it is doable with the following modification:</div><div><br></div><div><font face="monospace, monospace">run uccx sql db_cra select limit 1 a.applicationname, a.privatedata, t.triggername from crsapplication as a left join crstrigger as t on a.applicationname = t.applicationname where a.active = 't' and t.active = 't'</font><br></div><div><br></div><div>I really don't recommend running that command and expecting any useful output. Like I said, the PrivateData column as a BLOB of just binary bits ruins the output.</div><div><br></div><div>So, to get the list of triggers and apps separate from the script name (the ugly bit):</div><div><br></div><div><font face="monospace, monospace">run uccx sql db_cra select triggername, applicationname from crstrigger where active = 't'</font><br></div><div><br></div><div>Last but not least, I do have a series of python scripts which I use to scrape the web ui for all kinds of cool data. I even tweeted one out once:</div><div><br></div><div><a href="https://twitter.com/avholloway45633/status/647450649353846784" target="_blank">https://twitter.com/avholloway45633/status/647450649353846784</a><br></div><div><br></div><div>I don't like to just give away custom code, because it's kind of like showing someone your bedroom closet. If you know what I mean. So, if there's interest in seeing my closet, I'll clean it up first. ;)</div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Jun 21, 2016 at 11:19 AM, Brian V <span dir="ltr"><<a href="mailto:bvanbens@gmail.com" target="_blank">bvanbens@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">All you SQL gurus out there :)<br>
<br>
I'm hoping there is a quick way to accomplish a task.<br>
<br>
I recently inherited a UCCX 10.6 install with 39 applications defined.<br>
<br>
I need to document the application name, the script assigned to the application, and the trigger(s) assigned to the application<br>
<br>
I only have WebEx access to a shared desktop at the customer. That desktop has a browser and Putty.<br>
<br>
I have HTTP and SSH access to the UCCX system via the remote desktop.<br>
<br>
Does anyone know how to write a quick SQL CLI statement to gather this info in one go ?<br>
<br>
<br>
Thanks !<br>
<br>
_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" rel="noreferrer" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
</blockquote></div><br></div>
</div></div><br>_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" rel="noreferrer" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
<br></blockquote></div><br></div>