1

Creating a script to list of installed software on multiple computers is the first important step in implementing centralized software inventory for your network. Also, this method of building a list of installed programs in the system can be useful before reinstalling the system when you need to find unwanted software. Information about installed applications should include product name, vendor, version, install path and some other data. This guide describes how to create a script to list installed software on multiple computers and save the list of installed programs to CSV file.

Step 1: Execute WMI Query in ROOT\CIMV2 Namespace:

– Launch WMI Explorer or any other tool which can run WMI queries.

– Run WMI query: SELECT * FROM Win32_Product

Step 2: Open WMIC Command-line Interface:

– Press WIN+R

– Type “wmic”, press Enter

– In wmic command line tool type: /node:RemoteComputerName product

Step 3: Run This Simple Windows Powershell Script:

– thru WMI object:

Get-WmiObject -Namespace ROOT\CIMV2 -Class Win32_Product -Computer RemoteComputerName

– thru Windows Registry:

Get-ItemProperty HKLM:\Software\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall\* | Select-Object DisplayName, DisplayVersion, Publisher, InstallDate

– thru Get-RemoteProgram cmdlet:

Get-RemoteProgram -ComputerName RemoteComputerName

Step 4: Use Following Code to Select Specific Columns:

– execute:

Get-WmiObject -Namespace ROOT\CIMV2 -Class Win32_Product -Computer RemoteComputerName | Select-Object Name, Version, PSComputerName

Step 5: Sort the Results Using the Line Below:

– invoke command:

Get-WmiObject -Namespace ROOT\CIMV2 -Class Win32_Product -Computer RemoteComputerName | Select-Object Name, Version, PSComputerName | Sort-Object Name

Step 6: The Next Code Helps to Filter Results:

– use it:

Get-WmiObject -Namespace ROOT\CIMV2 -Class Win32_Product -Computer RemoteComputerName | Select-Object Name, Version, PSComputerName | Where-Object -FilterScript {$_.Name -like “Microsoft*”}

Step 7: Save Results to CSV File:

– run:

Get-WmiObject -Namespace ROOT\CIMV2 -Class Win32_Product -Computer RemoteComputerName | Select-Object Name, Version, PSComputerName | Export-CSV “c:\file.csv” -Append -NoTypeInformation

Step 8: Query Multiple Computers:

#computers from a text file: 
Get-Content -Path c:\computers.txt | ForEach-Object { Get-WmiObject -Namespace ROOT\CIMV2 -Class Win32_Product -Computer $_ }

#computers from AD domain: 
Get-ADComputer -Filter { OperatingSystem -Like ‘Windows 10*’ } | ForEach-Object { Get-WmiObject -Namespace ROOT\CIMV2 -Class Win32_Product -Computer $_.Name }

Using Action1 RMM solution you can Built-in Reports/Installed Software report and get necessary data in a few clicks instead of tinkering with PowerShell.

5 Spice ups