SCCM report for IE Versions

I had a requirement to create an SCCM report to get the Machine name, User name, User Domain and IE version.

I have created a report with ARP.DisplayName0 like “Internet Explore”. The report worked like a charm but added all the IE add-ins, IE updates and IE hotfixes and the report spanned thousands of lines. So I needed to exclude the IE updates and Hotfixes then include only the IE Versions.

So the requirement is;

-          Machine name

-          User name

-          User Domain

-          IE version (Exclude IE add-ins, IE updates and IE hotfixes)

Below SQL query provides above information;

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

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%')

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

More SCCM custom reports can be found here

*****An updated article published here to get all the versions of Internet explorer.*****

Report by venu Singireddy