SCCM report/collection for computers with Internet Explorer with different versions

http://eskonr.com/2010/04/sccm-reportcollection-for-computers-with-internet-explorer-with-different-versions/

http://www.windows-noob.com/forums/index.php?/topic/1799-simple-report-for-counting-ie-versions/

Asset Inteligence Feature: v_GS_INSTALLED_EXECUTABLE

SELECT ExecutableName0, ProductVersion0, count(*)
FROM
v_GS_INSTALLED_EXECUTABLE
WHERE ExecutableName0 = ‘iexplore.exe’ and ProductVersion0 LIKE ‘8%’
GROUP BY ExecutableName0, ProductVersion0
Order by ExecutableName0

 

**************************************************************************

Select Distinct

sys.Netbios_Name0,

sys.User_Domain0,

sys.User_Name0,

arp.Displayname0

FROM

v_R_System sys

JOIN

v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID

WHERE

ARP.DisplayName0 like ‘%Internet Explorer%’ and (DisplayName0 not like ‘%Security Update%’ and DisplayName0 not like ‘%Update For Windows%’ and DisplayName0 not like ‘Hotfix%’)

**************************************************************

 

SCCM report or collection for computers with Internet Explorer with different versions(fixed):

http://www.bingbt.com/2013/05/sccm-report-or-collection-for-computers-with-internet-explorer-with-different-versionsfixed.html

 

select distinct
b.Caption0,
c.FileDescription +’ ‘+left(c.fileversion,3) as ‘Version’,
count(c.FileDescription +’ ‘+left(c.fileversion,3)) as ‘Count’
from v_r_system a inner join v_gs_Operating_system b on a.resourceid=b.resourceid
inner join v_GS_SoftwareFile c on a.resourceid=c.resourceid
where c.FileName = ‘iexplore.exe’ AND c.FilePath like ‘C:\prog%internet%’
and (a.client0=1 and a.Obsolete0=0 and a.Active0=1) and b.Caption0 like’%professional’
Group By c.FileDescription +’ ‘+left(c.fileversion,3),b.Caption0