Your company's ad could live here and reach over 50,000 people a month!

Share This Post

List of machines with Microsoft Internet Explorer (IE)

This query lists all the machines with a copy of Microsoft Internet Explorer (IE) by Version, and Service Pack.

* Requires BDNA Normalize CM

Manufacturer

Product Name

Service Pack/Patch

Major Version

Microsoft

Internet Explorer

 

10

Microsoft

Internet Explorer

 

9

Microsoft

Internet Explorer

 

8

Microsoft

Internet Explorer

 

7

Microsoft

Internet Explorer

SP0 (on Windows XP Media Center Edition 2002 SP3)

7

Microsoft

Internet Explorer

SP0 (on Windows XP Home SP3)

7

Microsoft

Internet Explorer

SP0 (on Windows XP Media Center Edition 2002 SP2)

7

Microsoft

Internet Explorer

SP0 (on Windows Server 2003 SP1)

7

Microsoft

Internet Explorer

SP0 (on Windows XP Professional X64 edition)

7

Microsoft

Internet Explorer

SP0 (on Windows XP Professional SP2)

7

Microsoft

Internet Explorer

SP0 (on Windows XP Media Center Edition 2004 SP2)

7

Microsoft

Internet Explorer

SP0 (on Windows XP Home SP2)

7

Microsoft

Internet Explorer

SP0 (on Windows XP Professional SP3)

7

Microsoft

Internet Explorer

SP0 (on Windows XP Media Center Edition 2004 SP3)

7

Microsoft

Internet Explorer

SP0 (on Windows Vista SP1)

7

Microsoft

Internet Explorer

SP0 (on Windows Vista)

7

Microsoft

Internet Explorer

 

6

Microsoft

Internet Explorer

SP2

6

Microsoft

Internet Explorer

SP0 (on Windows Tablet PC Edition SP2)

6

Microsoft

Internet Explorer

SP1 (on Windows XP Home SP1)

6

Microsoft

Internet Explorer

SP1 (on Windows XP Professional)

6

Microsoft

Internet Explorer

SP1 (on Windows Millennium)

6

Microsoft

Internet Explorer

SP1 (on Windows 2000 SP4)

6

Microsoft

Internet Explorer

SP0 (on Windows XP Professional x64 Edition)

6

Microsoft

Internet Explorer

SP0 (on Windows XP Media Center Edition 2004 SP2)

6

Microsoft

Internet Explorer

SP0 (on Windows XP Media Center Edition 2002 SP2)

6

Microsoft

Internet Explorer

SP0 (on Windows XP Home Edition SP2)

6

Microsoft

Internet Explorer

SP1 (on Windows 2000 SP3)

6

Microsoft

Internet Explorer

SP1 (on Windows 2000)

6

Microsoft

Internet Explorer

Gold (SP0) (on Windows 98 SE)

6

Microsoft

Internet Explorer

Gold (SP0) (on Windows 2000 Professional SP4)

6

Microsoft

Internet Explorer

Gold (SP0) (on Windows XP Professional)

6

Microsoft

Internet Explorer

Gold (SP0) (on Windows XP Home Edition)

6

Microsoft

Internet Explorer

SP0 (on Windows XP Media Center Edition 2004 SP3)

6

Microsoft

Internet Explorer

Gold (SP0) (on Windows NT 4.0 Server SP6a)

6

Microsoft

Internet Explorer

SP1 (on Windows XP Home Edition)

6

Microsoft

Internet Explorer

SP1 (on Windows NT Workstation 4.0)

6

Microsoft

Internet Explorer

SP1 (on Windows NT Server 4.0)

6

Microsoft

Internet Explorer

SP1 (on Windows 98 SE)

6

Microsoft

Internet Explorer

SP1 (on Windows 98)

6

Microsoft

Internet Explorer

SP1 (on Windows 2000 SP2)

6

Microsoft

Internet Explorer

SP1 (on Windows 2000 SP1)

6

Microsoft

Internet Explorer

Gold (SP0) (on Windows NT 4.0 Workstation SP6a)

6

Microsoft

Internet Explorer

SP0 (on Windows XP Professional SP2)

6

Microsoft

Internet Explorer

SP0 (on Windows Tablet PC Edition SP3)

6

Microsoft

Internet Explorer

SP1 (on Windows XP Professional SP1)

6

Microsoft

Internet Explorer

Gold (SP0) (on Windows 2000 Professional SP3)

6

Microsoft

Internet Explorer

SP0 (on Windows XP Media Center Edition 2002 SP3)

6

Microsoft

Internet Explorer

SP0 (on Windows XP Home Edition SP3)

6

Microsoft

Internet Explorer

SP0 (on Windows 2000)

6

Microsoft

Internet Explorer

Gold (SP0) (on Windows Millennium)

6

*The list above is not exhaustive, and only provided a sample of the data that are available within CM.

Using the new CM class BDNA_SOFTWARE_DATA, all your inventoried software are now available into a single table. You can query this table using WQL or SQL.

WQL

select System.Name, Software.Publisher, Software.Family, Software.SoftwareName, Software.Component, Software.MinorVersion, Software.MajorVersion, Software.Edition, Software.Category1, Software.Category2 from SMS_R_System inner join SMS_G_System_BDNA_BDNASOFTWAREDATA_1_1 as Software on Software.SMSUniqueIdentifier = SMS_R_System.SMSUniqueIdentifier inner join SMS_R_System as System on System.SMSUniqueIdentifier = Software.SMSUniqueIdentifier where Software.Publisher = "Microsoft" and Software.SoftwareName = "Internet Explorer"

SQL

SELECT v_R_System.Name0 as Name, Software.Publisher0 as Publisher, Software.Family0 as Family, Software.SoftwareName0 as SoftwareName, Software.Component0 as Component, Software.MinorVersion0 as MinorVersion, Software.MajorVersion0 as MajorVersion, Software.Edition0 as Edition, Software.ServicePack0 as ServicePack, Software.Category10 as Category1, Software.Category20 as Category2

FROM v_R_System

INNER JOIN v_GS_BDNA_Software_Data0 Software ON Software.SMSUniqueIdentifier0 = v_R_System.SMS_Unique_Identifier0

WHERE Software.Publisher0 = ‘Microsoft’ AND Software.SoftwareName0 = ‘Internet Explorer’

Share This Post

A community professional, keynoter, and evangelist who has driven social media and marketing strategies, editorial successes, delivered customer successes and built some of the largest and longest-running online communities. Rod has created, managed and grown small, medium, and mega-sized conferences; run entire editorial teams to deliver record traffic and market leadership; as product manager, directed the success of hundreds of product releases; supported sales and marketing to ensure customer success; developed, run and sold businesses; written thousands of technical articles, white papers, case studies, and technical documentation; hosted and delivered hundreds of attendance shattering webinars and virtual tradeshows; and delivered keynote speeches and sessions at a wide variety of events including conferences, webinars, events, and user groups.

Leave a Reply