Exchange Online & Outlook Client Version Reporting with PowerShell

Posted on

For admins who may need to know what versions of Outlook is being used to connect against Exchange Online, you can use the following PowerShell command(s), which will allow you to save the information to .csv for later review. This information can be important in many ways, but specifically understanding the versions can tell you who is using older clients, which may be close to end-of-life or close to being blocked by Exchange Online, etc.

PowerShell Commands

Outlook Information – Saved to .csv file

Get-Mailbox | Get-LogonStatistics| where {$_.ApplicationID -match “Outlook”} | FT -Wrap -AutoSize –Property username,ApplicationID > EXO_Outlook_Version_Info.csv

All Client Connections – Saved to .csv file

Get-Mailbox | Get-LogonStatistics | FT -Wrap -AutoSize –Property username,ApplicationID > EXO_Connectivity_Info.csv

One thought on “Exchange Online & Outlook Client Version Reporting with PowerShell

    Michael said:
    October 30, 2014 at 11:31 am

    Get-logonstatistics is deprecated in Exchange 2013/Exchange Online.

    Thanks to Michael for this. Exchange 2013 no longer has this and with EXO this makes the need for different reporting options necessary. For those who are using this get-logonStatistics, please view this Office 365 Reporting Option. It may not provide everything you need, but without this specific EXO Remote PowerShell command, this is the best found right now: http://msdn.microsoft.com/en-us/library/office/jj984325(v=office.15).aspx

    Specifically look to the section where you can use Excel and the following URL, to connect into Office 365 and pull reports in many difference areas.

    Excel –> Data –> New oData connection –> URL: https://reports.office365.com/ecp/reportingwebservice/reporting.svc

    Thanks Michael!

Whatcha thinkin?

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s