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
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.
3 comments:
That is great. How do you add so that it will also display the Version#?
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"
Thank you so, so much. Very helpful and it did my job. God bless!
Abdu
Post a Comment