SMS collection help

SR Zak
SR Zak used Ask the Experts™
on
I would like to create a collection of all the Windows XP - 64 BIT PCs that have an application by the name "Adaptable 1.3" and  "Adaptable 2.3"

Can you please send me the query.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
This query requires all four elements that you are looking for:

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 inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceId = SMS_R_System.ResourceId where SMS_R_System.OperatingSystemNameandVersion like "%workstation 5.1%" and SMS_G_System_SYSTEM.SystemType like "%x64%" and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Adaptable 1.3%" and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Adaptable 2.3%"

This query requires 3 of the four elements in that it looks for XP - 64 - and either Adaptable 1.3 or Adaptable 2.3

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 inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_R_System.OperatingSystemNameandVersion like "%workstation 5.1%" and SMS_G_System_SYSTEM.SystemType like "%x64%" and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Adaptable 1.3%" or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Adaptable 2.3%"
SR ZakNetwork Solutions

Author

Commented:
Thanks for you help.
I was thinking if you can answer my other questions on SMS 2003 I posted.
Regards.

Commented:
I just used a Microsoft SMS Virtual Lab and the query should be backwards compatible.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial