Office 365 Report Gathering: Creating Reports of browser usage
In this blog we will see about the PowerShell command that is used to query & view the results of the browsers used by users in Grid View / CSV report.
This will be very useful when we want to query & view the results of users in bulk like more than 1000 or so.
Let’s see how we can achieve this.
Pre-Requisites:
=> Download & install Azure PowerShell for Office 365.
=> Next we have to connect to the Office 365 Exchange Online using the following commands:
$UserCredential = Get-Credential
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $UserCredential -Authentication Basic -AllowRedirection
Import-PSSession $Session
To View the results in Out-Grid View:
We can run the below command to view the browser usage result in Out-Griid View:
Get-O365ClientBrowserDetailReport | Out-GridView
After running the above command we can view the results in an Out-Grid view.
To view the results exported in CSV:
We can run the below command to view the browser usage result Exported in CSV:
Get-O365ClientBrowserDetailReport | Export-Csv C:tempBrowserUsage.csv
After running the above command you can view the results exported in a CSV file.
So is that all?? There are many other information we can gather in O365 using the list of commands below in the similar way:
Get-StaleMailboxDetailReport
Get-StaleMailboxReport
Get-MessageTraceDetail
Get-OutboundConnectorReport
Get-RecipientStatisticsReport
Get-ServiceDeliveryReport
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
Ratish Nair
Microsoft MVP | Exchange Server
Team @MSExchangeGuru
