Forum Discussion
Solved
Office 365 Reports - Missing Data
Hello.
I'm just new here. Hope someone can help me with my concern.
We are trying to export reports using powershell. We do this on a weekly and on a monthly basis.
It was working fine before. Until we noticed that some of the reports do not contain the latest data or somehow seized to produce the new dates.
Reports are:
A. SharePoint - Tenant Storage Metrics (daily)
B. Skype for Business - Peer-to-peer (daly)
C. SharePoint - Team Sites Deployed (monthly)
D. SharePoint - Team Sites Storage (monthly)
E. Mail - Types of Mailbox Connection (monthly)
Powershell:
A. Get-SPOTenantStorageMetricReport -ReportType Daily -StartDate $startwk -EndDate $endwk | Select Date, Used
B. Get-CsP2PSessionReport -ReportType Daily -StartDate $startwk -EndDate $endwk |Select-Object Date, TotalP2PSessions, P2PIMSessions, P2PAudioSessions, P2PVideoSessions, P2PApplicationSharingSessions, P2PFileTransferSessions
C. Get-SPOTeamSiteDeployedReport -ReportType Monthly -StartDate $FirstDay -EndDate $LastDay | Select Date, Active, Inactive
D. Get-SPOTeamSiteStorageReport -ReportType Monthly -StartDate $FirstDay -EndDate $LastDay | Select Date, Used
E. Get-ConnectionByClientTypeDetailReport -ReportType Monthly -StartDate $global:Start -EndDate $global:End -ResultSize Unlimited | Select WindowsLiveID, UserName, ClientType, Count
As we look on the Reports via GUI - Old Admin Center, it seems that the data capturing has stopped to certain dates (like only upto Feb 2017 for SP, Apr 2017 for SfB, and Jan 2017 for Mail.)
Have we missed anything? Anyone experiencing the same delays in the reports? Thanks in advance.
Hi Rafael,
Last year in March, we started to roll out completely new usage reports in the Office 365 admin center that enable admins to understand usage of the various services within Office 365. Please take a look at the following blog posts and support articles for more information:
https://blogs.office.com/2016/03/15/new-reporting-portal-in-the-office-365-admin-center/
https://blogs.office.com/2016/09/13/new-usage-reports-for-sharepoint-onedrive-and-exchange/
In April, we are announcing the public preview of the Microsoft Graph reporting APIs that enables you to retrieve the usage data programmatically:
Please try out the new Microsoft Graph reporting APIs and let us know if this meets your needs.
Thanks,
Anne
- Anne Michels
Microsoft
Hi Rafael,
Last year in March, we started to roll out completely new usage reports in the Office 365 admin center that enable admins to understand usage of the various services within Office 365. Please take a look at the following blog posts and support articles for more information:
https://blogs.office.com/2016/03/15/new-reporting-portal-in-the-office-365-admin-center/
https://blogs.office.com/2016/09/13/new-usage-reports-for-sharepoint-onedrive-and-exchange/
In April, we are announcing the public preview of the Microsoft Graph reporting APIs that enables you to retrieve the usage data programmatically:
Please try out the new Microsoft Graph reporting APIs and let us know if this meets your needs.
Thanks,
Anne
- Hi Anne,
Actually, I'm already aware of the the New Reports that has been rolled out. I know that the delays in the reports are not unusual, but only for a couple of days and should be not weeks or months. Also. I was just hoping that reports thru PowerShell are still reliable. Well, I guess I have to adapt to the latest feature. Likewise, inform our customers what to expect on the new types of reports.
Thanks for sharing the articles. I will check them out and try the new feature.
Cheers,
Rafael
There's been a bit of reshuffling with reports lately, some of them have been moved around or deprecated. In addition, PowerShell cmdlets and the corresponding reporting webservices are no longer supported. You can get a list of the changes here: https://support.office.com/en-us/article/Where-did-my-Office-365-report-go-4f7ce026-8be0-4800-849c-28071df0b85f?ui=en-US&rs=en-US&ad=US
I know Anne Michels is aware of this, but doesnt hurt pinging her and showing that people care about those reports :)
- Thanks Vasil.
IMHO is not a problem from your scripts, it's more a problem of what you have seen: Data capturing has stopped at some times Anne Michels FYI
- That's what I thought.
I guess I have to find some other ways to produce my reports.
Thanks Juan.
