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.%"
ASKER