Ying Li at myITforum.com

PowerShell & System Center

ConfigMgr – Create a collection based on 64 bit Add/Remove Programs

Here is a query to create a collection based on 64 bit add/remove program

select SYS.ResourceID,SYS.ResourceType,SYS.Name,SYS.SMSUniqueIdentifier,SYS.ResourceDomainORWorkgroup,SYS.Client from SMS_R_System as sys inner join  SMS_G_System_ADD_REMOVE_PROGRAMS_64 on  SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID = sys.ResourceId where  SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like "%Microsoft Windows Server Update Services 3.0 SP1" order by sys.Name

Comments

No Comments