<div dir="ltr">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.<div><br></div><div>Thanks,</div><div>Nick</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Mar 8, 2017 at 3:40 PM, 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">I don't think the CUC API has an arbitrary SQL execution method call like AXL does.<div><br></div><div>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.</div><div><br></div><div>Here's a high level program flow in no particular actual language:</div><div><br></div><div><font face="monospace">results = Array()</font></div><div><div><font face="monospace">response = HTTP GET https://<connection-server>/<wbr>vmrest/users</font></div><div><font face="monospace">for each user in response.users:</font></div><div><font face="monospace"><span class="m_-5630290769599260292inbox-inbox-Apple-tab-span" style="white-space:pre-wrap"> userobjectid = response.</span><span style="background-color:rgb(249,249,249)">ObjectId</span></font></div><div><font face="monospace"><span style="white-space:pre-wrap"> alias = response.Alias</span> <span style="white-space:pre-wrap"><br></span></font></div><div><font face="monospace"><span class="m_-5630290769599260292Apple-tab-span" style="white-space:pre-wrap"> </span>response = HTTP GET https://<connection server>/vmrest/users/<<wbr>userobjectid>/<wbr>mailboxattributes</font></div><div><font face="monospace"><span class="m_-5630290769599260292Apple-tab-span" style="white-space:pre-wrap"> </span>count = response.<span style="background-color:rgb(249,249,249)">NumMessages</span></font></div><div><font face="monospace"><span class="m_-5630290769599260292inbox-inbox-Apple-tab-span" style="white-space:pre-wrap"> results.append(alias, count)</span> </font></div><div><font face="monospace">results.sort(count, DESC)</font></div><div><font face="monospace">for each result in results:</font></div></div><div><span style="white-space:pre-wrap"><font face="monospace"> print result.alias, results.count</font></span><br></div><div><span style="white-space:pre-wrap"><br></span></div><div><span style="white-space:pre-wrap">Oh, and this is probably a good time to plug my Firefox GreaseMonkey User Script which shows you the breakdown of message counts per folder, and even let's you empty the deleted items.</span></div><div><span style="white-space:pre-wrap"><br></span></div><div><span style="white-space:pre-wrap"><a href="https://twitter.com/avholloway45633/status/828515885769953280" target="_blank">https://twitter.com/<wbr>avholloway45633/status/<wbr>828515885769953280</a></span><br></div><div><span style="white-space:pre-wrap"><br></span></div></div><br><div class="gmail_quote"><div><div class="h5"><div dir="ltr">On Wed, Mar 8, 2017 at 2:52 PM Nick Barnett <<a href="mailto:nicksbarnett@gmail.com" target="_blank">nicksbarnett@gmail.com</a>> wrote:<br></div></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5"><div dir="ltr" class="m_-5630290769599260292gmail_msg">I found<a href="https://www.cisco.com/c/en/us/support/docs/unified-communications/unity-connection/118299-technote-cuc-00.html#anc8" class="m_-5630290769599260292gmail_msg" target="_blank"> this SQL query</a> 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:<br class="m_-5630290769599260292gmail_msg"><div class="m_-5630290769599260292gmail_msg"><br class="m_-5630290769599260292gmail_msg"></div><div class="m_-5630290769599260292gmail_msg"><p class="MsoNormal m_-5630290769599260292gmail_msg">run cuc dbquery unitymbxdb1 select FIRST <b class="m_-5630290769599260292gmail_msg"><span style="background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;background-color:yellow" class="m_-5630290769599260292gmail_msg">10</span></b> alias as UserID,
count (*) as messages \<span class="m_-5630290769599260292gmail_msg"></span></p>
<p class="MsoNormal m_-5630290769599260292gmail_msg">from vw_message, unitydirdb:vw_mailbox, unitydirdb:vw_user \<span class="m_-5630290769599260292gmail_msg"></span></p>
<p class="MsoNormal m_-5630290769599260292gmail_msg">where mailboxobjectid in \<span class="m_-5630290769599260292gmail_msg"></span></p>
<p class="MsoNormal m_-5630290769599260292gmail_msg">(select mailboxid from vw_mailbox where unitydirdb:
vw_user.objectid = unitydirdb:vw_mailbox.<wbr>userobjectid) \<span class="m_-5630290769599260292gmail_msg"></span></p>
<p class="MsoNormal m_-5630290769599260292gmail_msg">group by alias order by \<span class="m_-5630290769599260292gmail_msg"></span></p>
<p class="MsoNormal m_-5630290769599260292gmail_msg">messages desc<span class="m_-5630290769599260292gmail_msg"></span></p><p class="MsoNormal m_-5630290769599260292gmail_msg"><br class="m_-5630290769599260292gmail_msg"></p><p class="MsoNormal m_-5630290769599260292gmail_msg">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.</p><p class="MsoNormal m_-5630290769599260292gmail_msg"><br class="m_-5630290769599260292gmail_msg"></p><p class="MsoNormal m_-5630290769599260292gmail_msg">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.<br class="m_-5630290769599260292gmail_msg"></p><p class="MsoNormal m_-5630290769599260292gmail_msg"><br class="m_-5630290769599260292gmail_msg"></p><p class="MsoNormal m_-5630290769599260292gmail_msg">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?</p><p class="MsoNormal m_-5630290769599260292gmail_msg"><br class="m_-5630290769599260292gmail_msg"></p><p class="MsoNormal m_-5630290769599260292gmail_msg">Thanks,</p><p class="MsoNormal m_-5630290769599260292gmail_msg">Nick</p></div></div></div></div>
______________________________<wbr>_________________<span class=""><br class="m_-5630290769599260292gmail_msg">
cisco-voip mailing list<br class="m_-5630290769599260292gmail_msg">
<a href="mailto:cisco-voip@puck.nether.net" class="m_-5630290769599260292gmail_msg" target="_blank">cisco-voip@puck.nether.net</a><br class="m_-5630290769599260292gmail_msg">
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" rel="noreferrer" class="m_-5630290769599260292gmail_msg" target="_blank">https://puck.nether.net/<wbr>mailman/listinfo/cisco-voip</a><br class="m_-5630290769599260292gmail_msg">
</span></blockquote></div>
</blockquote></div><br></div>