SCCM Collection for Internet Explorer 7

I'm trying to create a collection that will give me machines that have Internet Explorer 7 and I'm getting machines that also have IE 8 in that collection.  Here is my query.  Check and the machines are showing that they have IE 8 in add/remove programs.

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_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Windows Internet Explorer 7"
m1721cAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

George SimosIT Pro Consultant - IT Systems AdministratorCommented:
I would suggest that you check also the exact version of IE7 which is "7.00.5730.1100" and "7.00.5730.1300" for Windows XP and Server 2003 and you may find all the version numbers here.
But I would also suggest first to add the file iexplore.exe which resides in "%ProgramFiles%\Internet Explorer" and add it also as a software metering rule (to use the software metering reports), then after your clients update their policy and run their software/hardware inventory they'll report back the version of IEexplore.exe they have installed.
So the query will not be a hard one to get the result you want (but don't search it in Add/Remove Programs, instead search it in software inventory via the resource explorer on a client machine through the CM console.
Also you can try the reports about software metering and asset intelligence when you gather the metering data as i described above.
MarkieSCommented:
Your Query works OK for me.

Do your machines that have IE8 have an IE8 upgraded from IE7.  So they have had IE7 in the past?
George SimosIT Pro Consultant - IT Systems AdministratorCommented:
A correction in the second paragraph: I mean at the beginning to include the path and the executable of Internet Explorer in the software inventory agent.
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

George SimosIT Pro Consultant - IT Systems AdministratorCommented:
MarkieS I have machines upgraded which have a distinct version of IE8 in the "%ProgramFiles%\Internet Explorer" and they aren't causing me this issue, have you seen this behaviour in your environment(s)?
MarkieSCommented:
Dont have this behaviour in my environment.  Just a 1st thought off top of head.

m1721c is trying to build a collection based on the query listed.  It works OK for me.  The bulk of my environment is IE8 with 7 machines IE7 - They listed perfectly using m1721c's query.

So the query would appear to be good.

The problem lies elsewhere...
m1721cAuthor Commented:
I agree with MarkieS.  I have some machines that I installed IE 8 on with a customized package using the IE Toolkit but they still show up in the IE7 collection...  Very strange.  I'm going to try the metering suggestion from gsimos.
m1721cAuthor Commented:
@gsimos,  ok created the metering rules, how do I configure the collection then to use that data?
George SimosIT Pro Consultant - IT Systems AdministratorCommented:
You don't have to configure any collection, you need to make sure that the "Software Inventory" agent is enabled (I would enable also the Hardware Inventory agent" which is a site wide setting and not a collection based one.
After that in the "Software Inventory" agent setting make sure you're inventorying the correct paths for program files (keep in mind that in x64 systems the 32 bit "Program Files" directory is named "Program Files (x86)" and its environment variable is %ProgramFiles(x86)% as it's shown in the images attached.
Finally set your Software Inventory in a shorter time period in order for the clients to update their policy and report back their inventories to the site server.
You may use the reports for your reporting needs.

Images:
   Enabling Software Inventory Client Agent (Site wide setting) Gathering Software Inventory for *.exe files in "Program Files" folder/subfolders
George SimosIT Pro Consultant - IT Systems AdministratorCommented:
Sorry, you need to create a query in order to use it for a collection membership :-) I'll give you details about that.
George SimosIT Pro Consultant - IT Systems AdministratorCommented:
Ok this is the query I used, as you can see I'm using a list of values in order to pickup any version of IE7 in the technet list I posted above (my 1st post), you may then use this to create a dynamic collection with members having Internet  Explorer 7 installed:


select distinct sys.Name, sys.SMSAssignedSites
, sys.OperatingSystemNameandVersion, sys.ResourceDomainORWorkgroup
, sys.LastLogonUserName, sys.IPAddresses, sys.IPSubnets, sys.ResourceId
, sys.ResourceType
 from  SMS_G_System_SoftwareProduct as prod inner join SMS_R_System as sys 
 on sys.ResourceId = prod.ResourceID
 where prod.ProductName = "Windows® Internet Explorer"
 and prod.ProductVersion in (
 "7.00.6001.1800","7.00.6000.16441","7.00.6000.16386","7.00.5730.1300","7.00.5730.1100")

Open in new window

George SimosIT Pro Consultant - IT Systems AdministratorCommented:
There reason I put a list of values instead of operator based (such as "less than") values is that it wasn't working ok for me as it was omitting the version stated for comparison when checked for >= or <= operators.
m1721cAuthor Commented:
the query has a syntax error,  Am i copying it correctly?

select distinct sys.Name, sys.SMSAssignedSites
, sys.OperatingSystemNameandVersion, sys.ResourceDomainORWorkgroup
, sys.LastLogonUserName, sys.IPAddresses, sys.IPSubnets, sys.ResourceId
, sys.ResourceType
 from  SMS_G_System_SoftwareProduct as prod inner join SMS_R_System as sys
 on sys.ResourceId = prod.ResourceID
 where prod.ProductName = "Windows® Internet Explorer"
 and prod.ProductVersion in (
 "7.00.6001.1800","7.00.6000.16441","7.00.6000.16386","7.00.5730.1300
m1721cAuthor Commented:
nevermind missed some of it, got it now.  trying what u said   gsimos
m1721cAuthor Commented:
not getting any machines in that collection.  also found that when i run a installed software report that both IE7 and IE8 show up as installed.  however if i look in add/remove programs only IE 8 is listed.  Perhaps this is my problem and if so any ideas on how to fix it?
George SimosIT Pro Consultant - IT Systems AdministratorCommented:
can you check at a machine the in the resource explorer (right click on it when displayed in a collection and select Start > Resource explorer) the history of software inventories?
Just to check that there is a double or not version inventoried, are those machines x64 O/S's because the version there might be double and different.....
George SimosIT Pro Consultant - IT Systems AdministratorCommented:
All I did for this query was a copy of the query "All Systems with Specified Software Product Name and Version" and modified for the specific product name and versions (also replaced the prompted values with simple values).
m1721cAuthor Commented:
Both IE 7 and IE8 are listed.  two files show up under ie7, bith are iedw.exe and say its IE crash detection.  think i need these files since i'm on IE8 now?  I'll post another screen shot with it
untitled1.JPG
untitled2.JPG
George SimosIT Pro Consultant - IT Systems AdministratorCommented:
We don't need these files, we need the filename "iexplore.exe" and it must reside in "%ProgramFiles%\Internet Explorer" and "%ProgramFiles(x86)%\Internet Explorer" for the 32 bit version on x64 machines.
All the other are just rendundant.
I can see that one of the files in your inventory is in the windows protection folder "%Windir%\system32\dllcache" which we are not interest to count :-)
m1721cAuthor Commented:
I added the entries to the software inventory but stil get nothing for the query
Untitled.jpg
merowingerCommented:
%PROGRAMFILES%
m1721cAuthor Commented:
Found this doing some more googling.  This worked for me



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.FilePath like "%\\Program Files\\Internet Explorer\\" and SMS_G_System_SoftwareFile.FileName like "iexplore.exe" and SMS_G_System_SoftwareFile.FileVersion like "7.%"
George SimosIT Pro Consultant - IT Systems AdministratorCommented:
Glad you sorted this out, it is a bit different from my approach but it contains the info i stated above :)
George SimosIT Pro Consultant - IT Systems AdministratorCommented:
Also keep in mind that you use a wildcard to determine IE7' version which might return any beta versions too!

I'd like also to tell you that by adding above in the Software Inventory the paths for %programfiles% is redundant because you already scan all local hard disks for *.exe files in the very first rule (entry). So you don't need them.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
George SimosIT Pro Consultant - IT Systems AdministratorCommented:
For the future readers please read all my posts for the complete solution.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Server OS

From novice to tech pro — start learning today.