UnityConnect SQL Query Last voicemail Received

[JeffG1]

Hello, I was wondering if anyone knew a SQL query to obtain the time stamp the user last received a voicemail?

And or  how about the last time the user accessed their VM box via the TUI

[Maren Mahoney]

I have one that will give you the metadata of all messages for a user. I save it as a text file and then open it in Excel with "fixed width" as the parameter for columns. Then you can sort.

Obtain Mailbox ID and then get metadata of messages in mailbox:
---------------------------------------------------------------
run cuc dbquery unitydirdb select mailboxid from vw_usersearchmailbox where alias = 'USER ALIAS HERE'
run cuc dbquery unitymbxdb1 select * from vw_messageaginginfo where mailboxobjectid = 'OBJECT ID FROM PREVIOUS COMMAND'
 - If you have more than one mailstore, be sure to reference the correct Mailbox Store on the second command

Note: For 'User Alias Here' and 'mailbox id of user' you need the single quotes even if the item is contiguous

@Carlo Poggiarelli can you provide help on this?

Maren

[Maren Mahoney]

And: The "User Data Dump" tool available via CiscoUnityTools.com had a field for "Total phone logins for the last 7 days". That might also be available via SQL, but if not or if you don't get an answer for that it's at least something.

Maren