Hi allI'm new to SCCM 2007 and am just attempting to create my first query. I've been asked to provide a list of all devices in two IP subnets that have Internet Explorer below version 7.My first attempt looked like this:select SMS_R_System.Name, SMS_G_System_SoftwareFile.FileName, SMS_G_System_SoftwareFile.FileVersion, SMS_R_System.IPAddresses from SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_NETWORK_ADAPTER_CONFIGURATION on SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName = "iexplore.exe" and SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPAddress like "10.161.232%" and SMS_G_System_SoftwareFile.FileVersion not like "8%" and SMS_G_System_SoftwareFile.FileVersion not like "7%"This gave me results which initially looked promising as I got a load of machines with iexplore.exe version 6.00.2900.5512 returned. However, on checking some of the machines listed I discovered they did actually have IE7 installed. From what I can see this is because IE6 appears under the Product Name 'Microsoft Windows Operating System' whereas IE7 appears as a separate entity named 'Windows Internet Explorer' in the software inventory.The next query I've built is as follows:select SMS_R_System.Name, SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPAddress, SMS_G_System_SoftwareProduct.ProductName, SMS_G_System_SoftwareProduct.ProductVersion, SMS_R_System.ResourceId from SMS_R_System inner join SMS_G_System_NETWORK_ADAPTER_CONFIGURATION on SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_SoftwareProduct on SMS_G_System_SoftwareProduct.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareProduct.ProductName like "%Internet Explorer%" and SMS_G_System_SoftwareProduct.ProductVersion like "7%" and SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPAddress like "10.161.228%"I believe this one lists all of the machines which do have Internet Explorer 7 installed on the specified subnet. My problem now is how to get from here to a list of machines within that subnet which don't have IE7. I'm not sure whether it's possible for me to use a SubSelect query to do this and am a bit confused about how I would go about doing this. I've tried a couple of attempts but each SubSelect query I've created comes back saying "configmgr returned an error".Any assistance with this would be massively appreciated. Apologies if I've overlooked something very simple which I most probably have. ThanksStewart

You can try below subselect query and see if this gives you the required results.Select SMS_R_System.Name from SMS_R_System where SMS_R_System.Name not in (select SMS_R_System.Name from SMS_R_System inner join SMS_G_System_NETWORK_ADAPTER_CONFIGURATION on SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_SoftwareProduct on SMS_G_System_SoftwareProduct.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareProduct.ProductName like "%Internet Explorer%" and SMS_G_System_SoftwareProduct.ProductVersion like "7%" and SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPAddress like "10.161.228%")

Hi VisalsahThanks very much for your suggestion. I've created a collection targeted at the subnet in question and ran this subselect against it and it seems to have done the trick!Many thanksStewart