Finding All Installed Apps From Add And Remove Programs From A List Of Machines

 

Use the queries below to find the installed applications from the Add and Remove programs (MSI Installed) table for a list of machines.

 

SQL Query:

 

Select

System.Name0,

Programs.DisplayName00 Application,

Programs.Publisher00 Publisher,

Programs.Version00 Version,

Programs.ProdID00 'Product Id',

Programs.InstallDate00 'Install date'

From Add_Remove_Programs_Data Programs

Join System_Disc System on Programs.MachineId = System.ItemKey

Where System.Name0 in

('MachineOne',

'MachineTwo')

 

Or you could create a collection and query the collection:

 

Note: _RES_COLL_SMS000ES is the “All windows XP Systems” Collection

 

 

Select

System.Name0,

Programs.DisplayName00,

Programs.InstanceKey,

Programs.InstallDate00,

Programs.ProdID00,

Programs.Publisher00,

Programs.MachineID,

Programs.RevisionID,

Programs.TimeKey,

Programs.Version00

From System_Disc System

Join Add_Remove_Programs_Data Programs on Programs.MachineID = System.ItemKey 

Join _Res_Coll_Sms000ES Collection on Collection.MachineID = System.ItemKey

 

Published Friday, November 17, 2006 7:42 PM by dhite
Filed under:

Comments

# Tinging’s Blog! - » Finding All Installed Apps From Add And Remove Programs From A List Of Machines

PingBack from http://www.tinging.org/blog/?p=15

Monday, November 20, 2006 8:49 PM by Tinging’s Blog! - » Finding All Installed Apps From Add And Remove Programs From A List Of Machines