SCCM - Inventoried Software doesn't show IE so I when I run query on IE versions, I get no results

In SCCM , my Inventoried Software doesn't show IE (except for v.7 and 8) so I when I run query on IE versions, I get no results.
If I do a software report, again, no IE (iexplore.exe)

Is it because the new versions of IE come in as KBs and aren't in add/remove programs?
How can I query for IE 9,10,11?

I tried this:

select SMS_R_System.Name, SMS_R_System.LastLogonUserName, SMS_R_System.LastLogonTimestamp 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 "10.%"
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Systems Specialist
First Thing , Internet explorer will be inventered using Software Invenotry Cycle, for that you have to make sure that you have enabled software inventory via "Client Setting" . Also you have to specify which files you want to inventor and from which path.  Please verify that you have configured software inventory to inventory *.exe files under %Program Files% and %Program Files (x86)%.

Once you are sure with above mentioned configuration.  then you can go to monitoring console in SCCM for software inventory report and there is ready  made reports availabel to get "computers with specific files".  You have to give Just file name "Iexporer.exe" and you will get inveontory with version details.
sy wittnetwork engineer


Thanks!  I forgot to get back to you.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial