Determine the user's version of Office / Office 365

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...

Answer 1

This power shell documentation may help you with this.

View account license and service details with Office 365 PowerShell

This is a starting point.

Answer 2

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