MSExchangeGuru.com

Learn Exchange the Guru way !!!

 

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

Leave a Reply

Categories

Archives

MSExchangeGuru.com