Office 365 Reporting : How do We Create Client reports of Browser Used in Out-Grid view / Exported to CSV

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

Pre-Requisites

  1. Download and Install Azure PowerShell for office 365
  2. 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

image
Figure 1: Command for Outgrid

After running the above command you will get the below result.

image
Figure 2: 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

image
Figure 3: Command for csv

After running the above command you will get the below results.

image
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

Tagged , . Bookmark the permalink.

One Response to Office 365 Reporting : How do We Create Client reports of Browser Used in Out-Grid view / Exported to CSV

  1. Frank says:

    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