Re: [cisco-voip] Execute sql query via vmrest on CUC (or alternatative approach)?

+100 From: cisco-voip [mailto:cisco-voip-boun...@puck.nether.net] On Behalf Of Anthony Holloway Sent: Wednesday, March 08, 2017 5:34 PM To: Nick Barnett Cc: Cisco VoIP Group Subject: Re: [cisco-voip] Execute sql query via vmrest on CUC (or alternatative approach)? Actually, now that I think

Re: [cisco-voip] Execute sql query via vmrest on CUC (or alternatative approach)?

, 2017 5:34 PM To: Nick Barnett Cc: Cisco VoIP Group Subject: Re: [cisco-voip] Execute sql query via vmrest on CUC (or alternatative approach)? Actually, now that I think about it. The User Data Dump utility can probably achieve the exact same results, and requires no programming knowledge at all

Re: [cisco-voip] Execute sql query via vmrest on CUC (or alternatative approach)?

Actually, now that I think about it. The User Data Dump utility can probably achieve the exact same results, and requires no programming knowledge at all. I see a few different columns to pull from in the utility like unread messages count and deleted items message count, but nothing that just sa

Re: [cisco-voip] Execute sql query via vmrest on CUC (or alternatative approach)?

I got a little too excited and wrote a starting Python script to get the Alias and Message counts and print them to stdout as a CSV format. You'll need the requests module, which if you don't already have it, you should get it. It's pretty nice for working with HTTP requests. Also, disclaimer, I

Re: [cisco-voip] Execute sql query via vmrest on CUC (or alternatative approach)?

Thanks Anthony and Brian. I think i can make this work, especially after reading your firefox script and your non-code example... I think i can hack this together with another project I made in python and probably get it to work. Thanks, Nick On Wed, Mar 8, 2017 at 3:40 PM, Anthony Holloway < av

Re: [cisco-voip] Execute sql query via vmrest on CUC (or alternatative approach)?

I don't think the CUC API has an arbitrary SQL execution method call like AXL does. Since the SQL query is effectively searching everyone's mailbox message counts, and then just filtering the output to you, you could write that same process using the CUPI API. Here's a high level program flow in

Re: [cisco-voip] Execute sql query via vmrest on CUC (or alternatative approach)?

Here's the Unity Connection APIs- http://docwiki.cisco.com/wiki/Cisco_Unity_Connection_APIs You should be able to use the CUMI API to get this info I would think- http://docwiki.cisco.com/wiki/Cisco_Unity_Connection_Messaging_Interface_(CUMI)_API http://docwiki.cisco.com/wiki/Cisco_Unity_Connecti

[cisco-voip] Execute sql query via vmrest on CUC (or alternatative approach)?

I found this SQL query to return a count of all message boxes in CUC. I modified it to return the top 10 by adding "FIRST 10" immediately after "select" on the first line: run cuc