For computers with windows 7 operating system,IE8 will not register in add and remove programs hence you can go with software file.This collection may list IE6,IE7 and IE 9 computers.

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_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.%")

for windows 7 SP1,you can use v_gs_operating_system view along with v_r_system view ,for IE11 and without IE11,you can go with software inventory what is explained in the IE blog post. i will post it later when time permits.

I am trying to deploy IE 11 through software updates(SCCM 2012 R2) but many machine shows as compliant even though they are running IE8. I believe it might be reporting compliant since there are registry entry present for IE11. Is there any way to fix that?

I am not sure if this is the correct link for asking some help.
Please forgive me for that.

Hope you are fine .
I have tried "Report for computers which has IE 7 Installed" and it works fine but final list
contains more than 10000 records .Could you please help to modify it so that the final report reflects only PC's which names begin with UA letters , for example
Thanx

I really like your blog.. very nice colors & theme. Did you create this website yourself or did you
hire someone to do it for you? Plz respond as I'm looking to design my own blog and would like to find out where u got this from.
appreciate it

When I am running SQL query to get IE versions installed on all systems based on software file (iexplore.exe, v_GS_SoftwareFile); it fetches all the iexplore.exe available on a particular system not the currently installed version of iexplore.exe .Hence we get multiple entries for a particular system.

Could you please help me out to get the current installed IE version on all system.

I found that using the query below which is slightly modified from Eswar's worked at finding more computers with whatever specific version of IE I was looking for... Notice the "%" after Program Files...

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

I am not even sure if this can be done. But I need to know if there is a way in SCCM 2012 to report on IE version usage? Not like IE 7 or 8, but as in 32 or 64 bit. I am trying to convince our IT manager that Java 64 bit is not necessary because most people in our firm dont even use IE 64 bit.

I used the "Report for computers which has IE 7 Installed" query, I just added "and Operating_System_Name_and0 LIKE 'Microsoft Windows NT Workstation%'" in order to scope only Windows workstations.
The problem is this query lists all IE7 versions installed, some computers appears a multiple times in my reports.
Is there a way to make computers appear only once even if multiple IE7 versions are installed?

Hi, I'm having a problem generating an SCCM report where we want to confirm that IE6 is not running on Windows 7 machines. Since IE 6 is not in Add/remove programs I running into difficulty coming up withan accurate report. Any suggestions would be appreciated. Thanks

The query which i posted is Collection not report.
To get report,try the below .Replace the quotes with original as the blog convert's them to fancy.

SELECT TOP (100) PERCENT dbo.v_R_System.Name0, dbo.v_GS_OPERATING_SYSTEM.LastBootUpTime0, DATEDIFF(Day,
dbo.v_GS_OPERATING_SYSTEM.LastBootUpTime0, GETDATE()) AS [Days since last boot], dbo.v_GS_OPERATING_SYSTEM.Caption0
FROM dbo.v_GS_OPERATING_SYSTEM INNER JOIN
dbo.v_R_System ON dbo.v_GS_OPERATING_SYSTEM.ResourceID = dbo.v_R_System.ResourceID
WHERE (DATEDIFF(Day, dbo.v_GS_OPERATING_SYSTEM.LastBootUpTime0, GETDATE()) > 7) AND (dbo.v_GS_OPERATING_SYSTEM.Caption0 LIKE '%xp%') OR
(dbo.v_GS_OPERATING_SYSTEM.Caption0 LIKE '%Windows 7%') OR
(dbo.v_GS_OPERATING_SYSTEM.Caption0 LIKE '%vista%')
ORDER BY [Days since last boot]

Hi Rajeev,
Logged off information will not be avilable in sccm and if you need it ,you may have get it somehow using registry information or status messges..never tried it before But
you can try this report for computers not restarted since 1 week

I have tried to use the SCCM query 'Collection for Computers which doesn't have IE8' but I keep getting a syntax error when I hit OK in the dialog box of the query statement it simply states : "This query has a syntax error. Are you sure you want to save it?"

I am assuming that the query is not meant to be run on the SQL server using the SQL query manager... but in SCCM console yes?

Please let me know because I am in need of a query to create a collection of machines that do NOT have IE8 installed so I can target them for IE8 deployment and your query cam up in the Microsoft blog and it looked like the one I needed.

query works correctly but the only change u need is replace the quoates(') around Iexplore and 8 as they do not work in sccm reports.
btw.,did you enable software inventory agent looks for *.exe files ? without any exclusions to c:\program files ?

Mark,
what does the error message gives you when you run report Report for Computers which doesnt have IE8 Installed (which may have IE7 or IE9 ) ? Its working for me and i can see all computers with IE versions except IE8.

Collection for computers which doesn’t have Internet Explorer(IE8): Yes,it is not a SQL(Reports uses SQL) and it is WQL (collection uses WQL language). Query is correct but that doesnt list computers with IE8 because ,not like function will not return the correct restuls though. I have updated the collection query with subslected function. This should make you clear on this.