Hi All,

I have SCCM 2007 R3 and I need to create report to list all computers with chrome or Mozilla browser all editions. any help?

Thanks,

you may try below query:

SELECT R.Name0, ARP.DisplayName0, ARP.Version0 FROM v_R_System AS R INNER JOIN v_FullCollectionMembership ON R.ResourceID = v_FullCollectionMembership.ResourceID LEFT OUTER JOIN v_Add_Remove_Programs AS ARP ON R.ResourceID = ARP.ResourceID

WHERE (ARP.DisplayName0 LIKE '%SOFTWARE NAME%') AND (v_FullCollectionMembership.CollectionID= 'COLLECION ID')

Thanks Prashant,

it works well with me. do you know how to create same report for internet explorer 9 and 10?

Thanks,

you may try below SCCM query to show all IE version systems.

select distinct SMS_R_System.Name, SMS_G_System_SoftwareFile.FilePath, SMS_G_System_SoftwareFile.FileVersion 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.FilePath like "%program files%"

The above one is SMS collection query. For SQL report you may try the below query:

SELECT DISTINCT a.Name0 AS [Computer Name],
b.SiteCode,c.FileVersion AS [IE Version],
d.Operating_System_Name_and0
FROM v_GS_SoftwareFile c INNER JOIN
v_GS_SYSTEM a ON c.ResourceID = a.ResourceID INNER JOIN
v_R_System d ON a.ResourceID = d.ResourceID INNER JOIN
v_FullCollectionMembership b ON a.ResourceID = b.ResourceID
WHERE (c.FileName = 'iexplore.exe')
ORDER BY a.Name0

P.S: I know you had asked for a single query with 9 and 10 versions, but i m still testing on it..

Update to my earlier query to get IE 8 and IE 9 in a single report..

SELECT DISTINCT a.Name0 AS [Machine Name],
c.FileVersion AS [IE Version],
os.Caption0 as 'Operating System'

FROM v_GS_SoftwareFile c
INNER JOIN v_GS_SYSTEM a ON c.ResourceID = a.ResourceID
inner join v_GS_OPERATING_SYSTEM os on os.ResourceID = a.resourceid
INNER JOIN v_R_System d ON a.ResourceID = d.ResourceID 
INNER JOIN v_FullCollectionMembership b ON a.ResourceID = b.ResourceID

WHERE  c.FileName = 'iexplore.exe'
and os.caption0 <> '%server%'
and c.FileVersion like '9%'
or c.FileVersion like '10.%'
and c.FilePath like 'C:\Program Files\Internet Explorer%' 

ORDER BY c.FileVersion

I tested this query and it seems working however I saw a lot of duplicate records as below snapshot

any ideas?

That's because of Multiple versions of IE 9 and IE 10 installed on the machines. Refer to Release History of Internet Explorer : http://support.microsoft.com/kb/969393

I also found on Wikipedia that the below versions are said to be final releases.

Please verify with your IT team and use that version on the q

That's because of Multiple versions of IE 9 and IE 10 installed on the machines. Refer to Release History of Internet Explorer : http://support.microsoft.com/kb/969393

I also found on Wikipedia that the below versions are said to be final releases.

Please verify with your IT team and use that version on the q

The above one is SMS collection query. For SQL report you may try the below query: 

query for IE 10

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.FileName = "iexplore.exe" and SMS_G_System_SoftwareFile.FilePath like "%prog%internet%" and SMS_G_System_SoftwareFile.FileVersion like "10.%"

query for IE 9

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.FileName = "iexplore.exe" and SMS_G_System_SoftwareFile.FilePath like "%prog%internet%" and SMS_G_System_SoftwareFile.FileVersion like "9.%"

query for IE 10

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.FileName = "iexplore.exe" and SMS_G_System_SoftwareFile.FilePath like "%prog%internet%" and SMS_G_System_SoftwareFile.FileVersion like "11.%"