Windows PowerShell Office 365 reporting cmdlets
Summary: Use Windows PowerShell report cmdlets to Manage Office 365 using Windows PowerShell cmdlets, scripts, and batch processes.
If you are building a script that responds to trends in usage patterns, then Windows PowerShell cmdlets might be the right thing for you to use. Note that Windows PowerShell can also call the REST web service directly, which avoids the limitations of a remote Windows PowerShell session (as compared to a local Windows PowerShell session).
REST web service: If you're building a mobile app, a traditional Windows application, or a website reporting front-end, then the REST web service is much easier to use. The REST web service carries read-only historical data, and is useful for establishing trends. The data can be returned as a runtime ODATA source, and making HTTP requests is very easy in the Microsoft .NET Framework. For more information about the REST web service, see Office 365 Reporting web service.
Exchange Online reporting cmdlets
Get-ConnectionByClientTypeDetailReport
Get-ConnectionByClientTypeReport
Get-GroupActivityReport
Get-HistoricalSearch
Start-HistoricalSearch
Stop-HistoricalSearch
Get-MailboxActivityReport
Get-MailboxUsageDetailReport
Get-MailboxUsageReport
Get-MailDetailDlpPolicyReport
Get-MailDetailMalwareReport
Get-MailDetailSpamReport
Get-MailDetailTransportRuleReport
Get-MailFilterListReport
Get-MailTrafficPolicyReport
Get-MailTrafficReport
Get-MailTrafficSummaryReport
Get-MailTrafficTopReport
Get-MessageTrace
Get-MessageTraceDetail
Get-OutboundConnectorReport
Get-RecipientStatisticsReport
Get-ServiceDeliveryReport
Get-StaleMailboxDetailReport
Get-StaleMailboxReport
Lync Online reporting cmdlets
Get-CsActiveUserReport
Get-CsAVConferenceTimeReport
Get-CsConferenceReport
Get-CsP2PAVTimeReport
Get-CsP2PSessionReport
Office 365 reporting cmdlets
Get-O365ClientBrowserReport
Get-O365ClientOSReport
SharePoint Online reporting cmdlets
Get-SPOActiveUserReport
Get-SPOSkyDriveProDeployedReport
Get-SPOSkyDriveProStorageReport
Get-SPOTeamSiteDeployedReport
Get-SPOTeamSiteStorageReport
Get-SPOTenantStorageMetricReport
See Also
Manage Office 365 with Windows PowerShell
Advantages of using Windows PowerShell to manage Office 365
Getting started with Windows PowerShell in Office 365
Automate Office 365 tasks with Windows PowerShell
Manage user accounts and licenses
Use Windows PowerShell to create reports in Office 365
Windows PowerShell in Office 365 technical reference