Windows PowerShell Office 365 reporting cmdlets

  • Article

 

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