none
Determine the user's version of Office / Office 365 RRS feed

  • Question

  • I am trying to save some user environment information and I am running into trouble finding a way to obtain Office 365 specific information.  How can I programmatically get the Subscription and Excel Version (full version) as displayed in About Excel?

    I would like 4 pieces of information, really:

    • How to simply detect whether it is Office 365 vs desktop version of Office
    • Human readable Version Name of the office product
      (e.g. Microsoft Office 365 ProPlus vs Microsoft Office Professional Plus 2016)
    • Human readable Version Identifier as displayed in 'About Excel'
      (e.g. Microsoft Excel 2016 MSO (16.0.9126.2259) 64-bit)
    • Office 365 Version and Channel
      (e.g. Version 1803 Semi-annual Channel

    Thanks for any help...

    Wednesday, September 12, 2018 6:37 PM

All replies

  • This power shell documentation may help you with this.

    View account license and service details with Office 365 PowerShell

    This is a starting point.

    • Proposed as answer by Paras Dodhia Wednesday, September 19, 2018 12:29 AM
    Tuesday, September 18, 2018 11:58 PM
  • To view all the services for a user who has been assigned multiple licenses, use the following syntax:

    $userAccountUPN="<user account UPN>"
    $AllLicenses=(Get-MsolUser -UserPrincipalName $userAccountUPN).Licenses
    $licArray = @()
    for($i = 0; $i -lt $AllLicenses.Count; $i++)
    {
    $licArray += "License: " + $AllLicenses[$i].AccountSkuId
    $licArray +=  $AllLicenses[$i].ServiceStatus
    $licArray +=  ""
    }
    $licArray

    • Proposed as answer by Paras Dodhia Wednesday, September 19, 2018 12:29 AM
    Tuesday, September 18, 2018 11:59 PM