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 [email protected] https://puck.nether.net/mailman/listinfo/cisco-voip
