SCCM report/collection 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):
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