Query to list both X64 and X86 system with a program installled.

The following query returns all the x64 and x86 systems that are installed with VMWare tools.  You can replace “VMware Tools” with your program Add Remove Program’s to query for other programs.

select SMS_R_System.NetbiosName from  SMS_R_System where SMS_R_System.ResourceId in (select SMS_R_System.ResourceID  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 = "VMware Tools") or SMS_R_System.ResourceId in (select SMS_R_System.ResourceID from  SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS_64 on SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID = SMS_R_System.ResourceId where  SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName = "VMware Tools") order by SMS_R_System.NetbiosName


Unknown said...

That is great. How do you add so that it will also display the Version#?

Anonymous said...

This is a WQL Collection query so there will be no Version# column, but you could query for version by adding this line after the DisplayName query inside the parenthesis:

and SMS_G_System_ADD_REMOVE_PROGRAMS.Version = "1.0"

Anonymous said...

Thank you so, so much. Very helpful and it did my job. God bless!


Post a Comment