In Office 365, If we need to see more than 1,000 results for Browsers used and Operating systems used, we will have to use Exchange Online PowerShell. You can create a PowerShell script to export the data from the reports to a CSV file too.
In Below Example we have demonstrated to View / Export the browser used by office 365 Clients
- Download and Install Azure PowerShell for office 365
- Connect to office 365 Exchange Online using the following command
$UserCredential = Get-Credential
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $UserCredential -Authentication Basic -AllowRedirection
Import-PSSession $Session
Step 1 – For Out grid View
The command to Execute is Get-O365ClientBrowserDetailReport | Out-GridView
After running the above command you will get the below result.
Please note: For security reason’s certain information’s are hidden.
To Get the same Exported in CSV
The command to Execute is Get-O365ClientBrowserDetailReport | Export-Csv d:\clientbrowser.csv
After running the above command you will get the below results.
Figure 4: Result in CSV format
In similar we will be able to achieve other reports too in office 365, Below are few other commands related to office reporting can be used in similar way mentioned above.
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
Hope it helps
=================================================
Jason
Team@MseXchangeTeam.in
Hi, thanks for sharing. I have created a Report tool for Exchange Server 2010/2013 and Office 365, maybe it is interessting for the german users:
https://www.frankysweb.de/exchange-reporter-2013/
regdards, Frank