Huntland Services Ltd

Tel: +44 (0)1392-490518
Fax: +44 (0)1392-428003
Enquiries@huntland.co.uk

List Remote Installed Products

Introduction

Being able to tell what products have been installed using the MSI installer on a particular machine can be very useful when sorting software deployment problems for end users.   Common techniques for doing so include using the installer object.  Unfortunately this can't be used remotely.  WMI supplies the Win32_Product class which can be accessed remotely but only reports products that have been installed on a per machine basis or for the currently logged on user - in other words, not all products.

This solution will list all the products installed regardless of who installed them, will resolve the owner's account name and dump the results to screen, txt, csv or xml file.   It does this by collating the information from multiple registry locations taking advantage of the WMI Registry provider.

To use the script the operator must have admin privileges on the target system.  The script will only work if the operator's machine has MDAC and WMI installed (i.e. Win2k and above) and the target machine is currently using MSI version 2.0 or above.

Usage

cscript.exe ListRemoteInstalledProducts.vbs server1 server2 [C:\temp\myFile.xml]

Where:

Server1	The name or IP Address of the target system
Server2	The name or IP Address of the Domain Controller
[C:\temp\myFile.xml]	OPTIONAL - the full path and file name for the dump file.  The extension determines the format of the output.  Valid choices are *.xml, *.csv and *.txt

Notes:

The date format defaults to Europe.  For US style date formats modify the script at the beginning where commented

Output

The text output to screen or file is reduced to a subset of the total number of fields because of limitations of screen size.  The xml and csv output contain all the data.

Computer	The name of the targetted machine
Account	The user account name used to install the product
Sid	The Sid for the user account
LoggedOn	Whether at the moment the machine was scanned the  product's owner was currently logged on
ScrambledCode	The Product code used in the registry
ProductCode	The product Code as per the installer package
ProductName	The product name as per the installer package
ProductVersion	The version as per the installer package
InstallDate	The date when the product was installed by this user
CurrentDate	The date the scan was performed

Please accept scripts as is.  Any feed back will be gratefully received at Debug@huntland.co.uk