Remotely determine the Office Version installed

spiceuser-vqh2p · 2022-04-22T16:49:53.000Z

I have a bunch of remote computers I need to identify what version of MS Office they have installed. We need this so we can identify which computers are running Older versions of Office that are no longer supported or soon EOL. I tried a PS script to read the registry line HKLM:\Software\Microsoft\Windows\CurrentVersion\Uninstall

And WMIC and got all Microsoft products, but no o365 products

Any ideas other than sneaker net?

spiceuser-vqh2p · 2022-04-22T16:57:09.000Z

This is the PS script I ran as the Administrator:

foreach ($computer in (Get-Content C:\Script_tests\computers422.txt)) {
write-verbose “Working on $computer…” -Verbose
Invoke-Command -ComputerName “$Computer” -ScriptBlock {
Get-ItemProperty HKLM:\Software\Microsoft\Windows\CurrentVersion\Uninstall\O365ProPlusRetail* |
Select-Object DisplayName, DisplayVersion, Publisher
} | export-csv C:\results.csv -Append -NoTypeInformation
}

And this is the Response I received, I verified I could ping the computer:

VERBOSE: Working on FERWD23MAY2019…
[FERWD23MAY2019] Connecting to remote server FERWD23MAY2019 failed with the
following error message : The client cannot connect to the destination
specified in the request. Verify that the service on the destination is
running and is accepting requests. Consult the logs and documentation for the
WS-Management service running on the destination, most commonly IIS or WinRM.
If the destination is the WinRM service, run the following command on the
destination to analyze and configure the WinRM service: “winrm quickconfig”.
For more information, see the about_Remote_Troubleshooting Help topic.

CategoryInfo : OpenError: (FERWD23MAY2019:String) , PSRemotin
gTransportException
FullyQualifiedErrorId : CannotConnect,PSSessionStateBroken

ich-ni-san · 2022-04-22T17:24:09.000Z

spiceuser-vqh2p:

And WMIC and got all Microsoft products, but no o365 products

Don’t “o365” products stay up-to-date automatically as long as the subscription has been paid?

Neally · 2022-04-22T20:20:13.000Z

spiceuser-vqh2p:

this is the Response I received

are those machines on a domain?

Are those machines turned on and reachable?

I’d add a ‘test-connection’ to make sure the computer is available first.

Also, If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don’t say “Need help” or “PowerShell Help”, actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy…

Evan7191 · 2022-04-23T19:30:20.000Z

You can use Get-Package to find installed software, and it will return an object with a Version property to tell you the version of the software.

learn.microsoft.com

Get-Package (PackageManagement) - PowerShell

The Get-Package cmdlet returns a list of all software packages on the local computer that were installed with PackageManagement. You can run Get-Package on remote computers by running it as part of an Invoke-Command or Enter-PSSession command or...

robpoling · 2022-04-25T09:32:30.000Z

If you’re not tied to using PowerShell, PDQ Inventory would be a good way to scan your machines and get the Office version.

spiceuser-vqh2p · 2022-04-25T13:20:07.000Z

Yes, the computers are on a domain, and 90% are always on. the other 10% we can assume are running 365 (office workers). The shop ranges from Office 2010 to Office 365, I’m trying to identify which computers need to be updated without having to go to each computer. I have found a line that searches a certain string, but seems like it’s not specific enough if a computer has two versions installed, or if one version isn’t uninstalled correctly.

Get-WmiObject win32_product -ComputerName FERWD07JUL2019 | where{$_.Name -like "MICRISOFT office PRO*"} | select Name,Version

Evan7191 · 2022-04-25T13:50:17.000Z

spiceuser-vqh2p:

Yes, the computers are on a domain, and 90% are always on. the other 10% we can assume are running 365 (office workers). The shop ranges from Office 2010 to Office 365, I’m trying to identify which computers need to be updated without having to go to each computer. I have found a line that searches a certain string, but seems like it’s not specific enough if a computer has two versions installed, or if one version isn’t uninstalled correctly.
Get-WmiObject win32_product -ComputerName FERWD07JUL2019 | where{$_.Name -like "MICRISOFT office PRO*"} | select Name,Version

Win32_Product is bad.

learn.microsoft.com

Win32_Product class (Windows)

Warning  Win32_Product is not query optimized. Queries such as "select * from Win32_Product where (name like 'Sniffer%')" require WMI to use the MSI provider to enumerate all of the installed products and then parse the full list sequentially to handle the “where” clause. This process also initiates a consistency check of packages installed, verifying and repairing the install. With an account with only user privileges, as the user account may not have access to quite a few locations, may cause delay in application launch and an event 11708 stating an installation failure.

Have you tried using Get-Package? It has a parameter -AllVersions specifically for these situations.