none
O365 Reporting web service MailboxUsageDetail "$orderby=Date desc" not working RRS feed

  • Question

  • Running the following query (and I've tried may variations) and it does not return the latest record.  Even with no filter for the user ID and no $top it returns the oldest records first.

    <code>https://reports.office365.com/ecp/ReportingWebService/Reporting.svc/MailboxUsageDetail/?DelegatedOrg=nnn.onmicrosoft.com&$orderby=Date%20desc&$top=1&$select=Date,WindowsLiveID,CurrentMailboxSize&$filter=WindowsLiveID eq 'username@nnnn.com'</code>

    Is there a secret to how to order by the date field, or is it just broken?  Please--no speculative answers.  If you haven't run the command or don't have a reference to something that explains why it's not working, please refrain from answering in hopes that you might just get some points.

    Thanks!

    Tuesday, March 15, 2016 12:48 PM