Hy!Now i got another problem with a query:I made 2 queries to show which client has the ie7 or ie8 installed.Some clients were upgraded from ie7 to ie8 so they have 2 entries in the add/remove programs. One for the ie7 and another for the ie8.So i made the following query to show clients with ie8:select distinct SMS_R_System.Name, SMS_R_System.LastLogonUserName 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_R_System.Name not like "D%" and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Windows Internet Explorer 8" order by SMS_R_System.Name(If some clients got the ie8 then they have an entry in add/remove... and it´s the actual IE)For those who actually use the ie7:select distinct SMS_R_System.Name, SMS_R_System.LastLogonUserName 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_R_System.Name not like "D%" and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Windows Internet Explorer 7" and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Windows Internet Explorer 8" order by SMS_R_System.NameBut now the problem:I see the upgraded clients (from ie7 to ie8) also in this query although the statement "and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Windows Internet Explorer 8" "is used!!!!I want to select only these clients who were not upgraded.Something wrong in my thoughts???Frankyk

You have to use "subselect" queries to exclude systems that have software xyz installed: http://myitforum.com/cs2/blogs/jgilbert/archive/2008/07/22/subselect-queries-the-easy-way.aspx