Retrieving a mailbox's last login date/time via REST?

Version 1
    This document was generated from CDN thread

    Created by: Christopher Meier on 25-09-2013 01:51:58 PM
    I was browsing the .xsd files for CUC and found two fields in the MailboxDetail.xsd file that are of interest to me:
    LastGuiAccessTime and LastTuiAccessTime. I would like to access these, as my group is frequently asked to produce reports determining if mailboxes have been used recently or not.

    However, I can't seem to figure out the correct path to this resource. I've tried /vmrest/users/<OID>/mailboxdetails, /vmrest/mailbox/mailboxdetails?userobjectid=<OID>, and lots of other variations trying to find the way there.

    Is there a way to get to this information via REST?

    Subject: RE: Retrieving a mailbox's last login date/time via REST?
    Replied by: Jeff Lindborg on 25-09-2013 03:27:56 PM
    Christopher Meier:
    I was browsing the .xsd files for CUC and found two fields in the MailboxDetail.xsd file that are of interest to me:
    LastGuiAccessTime and LastTuiAccessTime. I would like to access these, as my group is frequently asked to produce reports determining if mailboxes have been used recently or not.

    However, I can't seem to figure out the correct path to this resource. I've tried /vmrest/users/<OID>/mailboxdetails, /vmrest/mailbox/mailboxdetails?userobjectid=<OID>, and lots of other variations trying to find the way there.

    Is there a way to get to this information via REST?

    it's done with a search construct like this: http://servername/vmrest/mailbox?userobjectid=xxxxxx  that said I don't think those fields get filled out - I don't have time to test it on a live server right now but I'm nearly certain the GUI login time is not updated - the TUI update time _may_ be updated but I can't promise that - so let me know what you find when you test it...

    Subject: RE: Retrieving a mailbox's last login date/time via REST?
    Replied by: Jeff Lindborg on 25-09-2013 03:46:28 PM
    ...just tested real quick on a 10.0 test server I have here and checked the database tables via ODBC (that REST is pulling from) and after logging in via the phone and checking messages and leaving a message the tui access time field is never filled in - which is what I remember.  There is a time of last login (which has nothing to do with the mailbox itself - it's a user value) but there's nothing for GUI mailbox access anywhere sofar as I know.  There's a time of last call table in the database that keeps track of the last time any subscriber signed in over the phone (authenticated into their account via the TUI more specifically) - I do not think this is exposed anywhere via REST, however - I plumbed it into the User Data Dump tool which works off ODBC access to the DB...

    Subject: RE: Retrieving a mailbox's last login date/time via REST?
    Replied by: Christopher Meier on 26-09-2013 02:42:06 PM
    Thanks, Jeff. For reasons I won't go into I don't have access to the ciscounitytools.com stuff, so getting information via REST works best for me. I got excited when I ran across the MailboxDetail.xsd schema doc with that field. However when looking at the application.wadl it doesn't look like that particular schema is referenced anywhere.

    So it looks like any access to that data has to come through polling the DB directly. Any suggestions for viewing those records under the condition that the User Data Dump tool or any other ciscounitytools.com items are NOT accessible?

    Appreciate it!

    Subject: RE: Retrieving a mailbox's last login date/time via REST?
    Replied by: Jeff Lindborg on 26-09-2013 03:31:27 PM
    the time of last login via the TUI is only available via ODBC so far as I know - doesn't appear anywhere else.  if for whatever reason you can't use that and/or any of our tools we provide then I'm not sure what else to suggest.