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

[Brian Meade]

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_Connection_Messaging_Interface_(CUMI)_API_--_Using_the_CUMI_API



On Wed, Mar 8, 2017 at 3:49 PM, Nick Barnett <nicksbarnett at gmail.com> wrote:

> I found this SQL query
> <https://www.cisco.com/c/en/us/support/docs/unified-communications/unity-connection/118299-technote-cuc-00.html#anc8>
> 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 dbquery unitymbxdb1 select FIRST *10* alias as UserID, count (*)
> as messages \
>
> from vw_message, unitydirdb:vw_mailbox, unitydirdb:vw_user \
>
> where mailboxobjectid in \
>
> (select mailboxid from vw_mailbox where unitydirdb: vw_user.objectid =
> unitydirdb:vw_mailbox.userobjectid) \
>
> group by alias order by \
>
> messages desc
>
>
> This works, but it's not very "dev ops friendly." I think I'd have to use
> an expect script and code in my CLI password... which I really don't want
> to do.
>
>
> I looked through the VMREST kit for CUC 10.5 and I don't see anything like
> this. I can usually find my way around the AXL kit in CUCM but I frequently
> have issues finding what I need in the CUC VMREST calls.
>
>
> Is there a way to execute this specific query via VMREST to CUC? Is there
> a VMREST call already baked into CUC that will return similar information?
>
>
> Thanks,
>
> Nick
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20170308/18f4ae3a/attachment.html>