base a collection on a security update is not installed
Hi how would i go about creating a collection based on a security update not being present on a windows XP machine. i have tried creating a collection using a system resource and using the criteria of add and remove displayname is not equal to "Security Update for Windows XP (KB958644)" but this does not work. at the moement windows update is not setup so i really need to find out how many systems do not have this update?thanks
December 15th, 2009 7:19pm

Hi,You can create a subselected query like this one:select distinct SMS_R_System.Name from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceId = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Security Update for Windows XP (KB958644)"Where the name of the update have to match how it's written in Add/remove programs.Kent Agerlund | http://scug.dk/members/Agerlund/default.aspx | The Danish community for System Center products
Free Windows Admin Tool Kit Click here and download it now
December 15th, 2009 7:24pm

You can create a subselected query like this one: ... but that one does not contain a subselect statement, so it won't work. Seehttp://myitforum.com/cs2/blogs/jgilbert/archive/2008/07/22/subselect-queries-the-easy-way.aspxfor details.
December 15th, 2009 7:30pm

You arethe You're right, I forgot to copy half the queru :-)select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.Name not in (select distinct SMS_R_System.Name from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceId = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Security Update for Windows XP (KB958644)")Kent Agerlund | http://scug.dk/members/Agerlund/default.aspx | The Danish community for System Center products
Free Windows Admin Tool Kit Click here and download it now
December 15th, 2009 7:35pm

Thanks Kent That's worked kind of but i forgot to mention that i also wanted to exclude servers 2003 if possible. if not ill just export to excel and cut out the servers.thanks Jason
December 16th, 2009 7:49pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics