Hi guys, I need to make a collection of windows xp with diffrenet internet explorer installed that includes intenet explorer versions that are not 6 (ie 7,8). I thought this one will be easy, but when i do the collection, i can't see that internet explorer is there, but everything else is (i don't know why microsoft doned that). any way, i try to do it an use file version, but even the file build version that i looked for is not there ( i wanted to do a collection based on the IE build) Anyway...this 5 minutes collection that thought it will be is now something like 1 hour (and yes, i even try to do this search using query but no luck.) I'll really appriciate your help on this... Hope to hear from you soon, Nahum

queries by file version can trip you up, check this out: http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/303e60cd-c4d5-4ab0-8bad-0005fc5e1b7d/ tesgroup

Try the following query on the collection: This query will list all windows xp system with IE7 or IE8 installed select * 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 like "%Windows NT Workstation 5.1%" and (SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Windows Internet Explorer 7" or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Windows Internet Explorer 8") Regards, Madan

Hi Tesgroup, If you'll read my post carefully again, you'll see that i already try to search for IE based the version (BUILD number to be more specific), but when i press the "value" button.... get a message that there is limit of 2000 items. I guess that if i knew the egistry key for that limit. i would change it, and maybe it would help. Right now, because of this built in limit, i cannot fine the IE build number that i want (i found a website with all the build numbers of IE but they are not in the list).

Hi Tesgrup, I found this article from microsoft on how to change the value of 2000 search limit....BUT i don't have the key in the regsitry, do i need to add it manually? does this link is valid for sccm 2007 r2 as well as sms 2.0 like this articled is applied to? here is the kb link. http://support.microsoft.com/kb/245648/EN-US/

Hi Eliash, Look at the Madan's query, it works well. Just make sure that the inventory is done on client machines. Bechir Gharbi | http://myitforum.com/cs2/blogs/bgharbi/default.aspx

Hi Bechir, Thanx for your reply, and you were right...it worked great on windows xp, BUT now i need to make the same collection, (all windows vista with IE diffrent then 7). here is the query i used...i get no result. 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 like "%Microsoft Windows NT Workstation 6.0%" and (SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Microsoft Internet Explorer 8%" or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Internet Explorer 8") Any idease Bechir? Hope to hear from you soon. Best regards, Nahum

Hi Nahum, you could try the following query for 'all windows vista with IE diffrent then 7' select * 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 like "%Windows NT Workstation 6.0%" and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName != "Windows Internet Explorer 7"Regards, Madan

Hi Mohan, I almost thought it worked, but after i did a little check, i found that my PC is in the collection. I guess that it's not working so well, althught the query looks fine, i wonder how can it be that i see my client in the collection? Maybe the solution here is to try to build a collection that finds the IE BUILD numbers, insted of looking in the add/remove programs. I sent a link from microsoft, here it is... http://support.microsoft.com/kb/245648/EN-US/ i don't have the key in my regsitry machine, how do i solve this issue, do i need to add it manually? (remember this KB talks about sms 2.0 and i have sccm 2007 r2). Hope to hear from you soon, Bestregards, Nahum

Hi Nahum, Yes, you are right. The above query was returning wrong result. Please find the corrected 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 where SMS_R_System.ResourceId not 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_R_System.OperatingSystemNameandVersion like "%Windows NT Workstation 6.0%" and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Windows Internet Explorer 7") On the other question, if you prefer to rely on the softwre inventory and version numbers, then the best method would be to inventory the SHDOCVW.dll. I use this method, because there is no add/remove programs entry for IE6 that comes with OS. Please refer to : http://myitforum.com/cs2/blogs/cstauffer/archive/2009/12/22/how-to-find-ie6-or-older-in-your-environment-with-sms-or-sccm.aspx for more info. on the KB and the values list from the query builder: Extract from ConfigMgr Help: Note The SMS Provider can run out of memory while caching a large result set. To avoid this and to maintain performance, Query Builder limits the number of values that are displayed in the Values dialog box to the first 2,000. You can override this by changing registry settings. For more information, see Microsoft Knowledge Base article Q269201. Please Refer to:http://support.microsoft.com/kb/269201 Regards, Madan

Here is the query which matches ur requirement: 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 not like “7.0%” Other reports/collection quiries on Internet Explorer are here: http://eskonr.wordpress.com/2010/04/21/create-a-report-to-get-machines-which-has-internet-explorer-7-installed-on-in-sccmsccm/ You can edit the query as per the requirement: //Eswar Koneti @ http://eskonr.wordpress.com/

Hi esawr, the query is not correct... I'm getting a synatax error.

Syntax error(typos) should occured at double quotes(" ") i think . Can you try with this now :Replace the double quotes at "iexplore.exe" and "7.0%" 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 not like "7.0%" //Eswar Koneti @ http://eskonr.wordpress.com/