SQL Query To List Add And Remove Programs For A Specified Machine Excluding Updates And Hot Fixes

 

This SQL Query will allow you to list the installed applications registered in the Add and Remove Applications applet for a specified machine excluding those applications such as Security Updates and Hot fixes and other system updates.

 

SQL Query:

 

Select

AP.DisplayName0 'Display Name',

IsNull(AP.Version0, '') Version

 

From v_R_System SD

Join v_Add_Remove_Programs AP on SD.ResourceID = AP.ResourceID

 

Where SD.Name0 = 'MachineName'

And AP.DisplayName0 Not Like '%Security Update%'

And AP.DisplayName0 Not Like '%Update For%'

And AP.DisplayName0 Not Like '%Hotfix%'

 

Order By AP.DisplayName0

 

 

 

 

Published Sunday, August 24, 2008 1:06 PM by dhite
Filed under:

Comments

No Comments