Hi all, I'm trying to build a collection for windows vista with IE8. I created a collection which looks like this: 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_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_R_System.OperatingSystemNameandVersion = "Microsoft Windows NT Workstation 6.0" and SMS_G_System_SoftwareFile.FileVersion = "8.00.6001" (This collection telles the SCCM t give ma all the clients with Windows vista anfd internet Explorer 8 (build number 8.00.6001). Unfortunatlly, i get ZERO results, when i specifically know that there are a few computers (maybe 20-30). When i try to change my collection, to look for the intenet explorer 8 in add remove programs, i get the same ZERO results. here is the collection i created 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_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceId = SMS_R_System.ResourceId where SMS_R_System.OperatingSystemNameandVersion = "Microsoft Windows NT Workstation 6.0" and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Windows Internet Explorer 8" Any idea why the sccm behaves like that??? Hope to hear from you soon, Nahum

In the first query,you will have use the filename ="iexplore.exe" Try with this query below : 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_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName = "iexplore.exe" and SMS_G_System_SoftwareFile.FileVersion like "8.0%" and SMS_R_System.OperatingSystemNameandVersion = "Microsoft Windows NT Workstation 6.0" //Eswar Koneti @ http://eskonr.wordpress.com/

Hi Eswar, Thanks for the reply. I'm still getting computers with IE 7. When i got the results, i checked some computers, and i've seen that they have IE7 installed, and only 1 cmputers in the collection list have IE8. (I got a collection of 830 client names). Any idea eswar, why do i get this result...do you have a lab test to check if you get the same result (mixed IE 7 AND 8), or do you get only the IE8 computers? Thanks againg, if you have something else for me to try, i'll be glad to hear about it.

Nope, it gave me the corret result in my environment and the query should not be listed computers with IE 7 since it looks for the computers with Iexplore and version. Can you check on the computer which shows both IE7 and IE 8, either Via RDP or Admin$ share and look at program files for iexplore.exe for the version.You can also check this Via Resource explorer,software products,microsoft below is another qeury which does the same : 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_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName = "iexplore.exe" and SMS_G_System_SoftwareFile.FilePath like "%prog%internet%" and SMS_G_System_SoftwareFile.FileVersion like "8.%" and SMS_R_System.OperatingSystemNameandVersion = "Microsoft Windows NT Workstation 6.0" //Eswar Koneti @ http://eskonr.wordpress.com/

My dear friend, God bless you, finally it looks fine...i tested about 7-8 machines from a total of 502 clients, and it looks great. thank you eswar, Have a great day Nahum, Israel.