Forum Discussion

Deleted's avatar
Deleted
Dec 20, 2016
Solved

Exporting list of Outlook client versions

Hi All,   I need to export an inventory of outlook client versions used by our end users. Can some one please advice?   i tried using Get-ConnectionByClientTypeDetailReport but it doesnot give Ou...
2013
2016
admin
exchange online
Exchange Server
hybrid
office 365
outlook
  • VasilMichev's avatar
    VasilMichev
    Dec 20, 2016

    Go to the O365 admin portal -> Reports -> Usage -> Email app usage -> press the Export button. No way to get this report via PowerShell afaik (Anne Michels might prove me wrong here).

     

    If you need even more details compared to what's shown in the report, down to the individual build number, you will have to browse the Audit logs and get the relevant data from them.

VasilMichev's avatar
VasilMichev
MVP
Dec 20, 2016

Go to the O365 admin portal -> Reports -> Usage -> Email app usage -> press the Export button. No way to get this report via PowerShell afaik (Anne Michels might prove me wrong here).

 

If you need even more details compared to what's shown in the report, down to the individual build number, you will have to browse the Audit logs and get the relevant data from them.

  • Anne Michels's avatar
    Anne Michels
    Former Employee
    Dec 22, 2016

    Thanks, Vasil.

    Please use the export button as described by Vasil to export any data from the usage reports at this point.

    In spring 2017, we will make new reporting APIs available that will allow you to programmatically access the information from the usage reports. Going forward, please use the APIs as the new usage reports will not be accompanied by PowerShell cmdlets.

    Thanks,

    Anne

  • Michelle Porreca's avatar
    Michelle Porreca
    Iron Contributor
    Dec 20, 2016

    This shows licenses, but not user versions. Like it won't show you if the user is running Office 2013 or Office 2016. That is what would be beneficial - to show what client version the user has installed.

    • NarasimaPerumal Chandramohan's avatar
      NarasimaPerumal Chandramohan
      MVP
      Dec 21, 2016

      Use the below EXO PowerShell script, here we use Search-MailboxAuditLog which has the client information. This method needs auditing to be enabled on all mailboxes and will be slower due to the audit log search.

       

      $UserCredential = Get-Credential
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri
https://outlook.office365.com/powershell-liveid/ -Credential $UserCredential -Authentication Basic-
AllowRedirection
Import-PSSession $Session

$mailboxs = Get-MailBox 
$mailboxs | Foreach-Object{
$mailbox=$_

Search-MailboxAuditLog -StartDate ([system.DateTime]::Now.AddDays(-2)) -EndDate ([system.DateTime]::Now.AddDays(+1)) -Operations MailboxLogin -Identity $mailbox.UserPrincipalName -ShowDetails|where-object{$_.ClientInfoString-like "*Client=Microsoft.Exchange.Mapi;*" -or $_.ClientInfoString -like "*Client=Microsoft.Exchange..Autodiscover;*" } |select LogonUserDisplayName,ClientInfoString,LastAccessed,ClientIPAddress -First 1 |fl
}

      Below is the sample output for a user.

Resources