
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-28-2012 05:17 PM
Does anyone have a report that will find all installed web browsers with version on all our computers - Firefox, Chrome, IE, etc.
Thanks!
Thanks!
Labels:
- Labels:
-
Archive
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-29-2012 11:03 AM
I'd use something similar to this, add each browser you want to check for to the where clauses...
-------------
Select Top 1000000 tblComputers.ComputerName, tblComputers.ComputerUnique As Machine , tblSoftware.softwareName As Product,
tblComputers.Domain, tblComputers.Username
From tblSoftware
Inner Join tblComputers On tblSoftware.ComputerName = tblComputers.Computername
Inner Join web40ActiveComputers On tblComputers.Computername = web40ActiveComputers.Computername
--Inner Join tblRegistry On tblComputers.Computername = tblRegistry.Computername
Where
tblSoftware.softwareName Like '%Google Chrome%'
OR tblSoftware.softwareName Like '%Safari%'
OR tblSoftware.softwareName Like '%Mozilla%'
Group By tblComputers.ComputerUnique, tblComputers.ComputerName, tblSoftware.softwareName, tblComputers.Domain, tblComputers.Username
Order By tblSoftware.softwareName
-------------
Select Top 1000000 tblComputers.ComputerName, tblComputers.ComputerUnique As Machine , tblSoftware.softwareName As Product,
tblComputers.Domain, tblComputers.Username
From tblSoftware
Inner Join tblComputers On tblSoftware.ComputerName = tblComputers.Computername
Inner Join web40ActiveComputers On tblComputers.Computername = web40ActiveComputers.Computername
--Inner Join tblRegistry On tblComputers.Computername = tblRegistry.Computername
Where
tblSoftware.softwareName Like '%Google Chrome%'
OR tblSoftware.softwareName Like '%Safari%'
OR tblSoftware.softwareName Like '%Mozilla%'
Group By tblComputers.ComputerUnique, tblComputers.ComputerName, tblSoftware.softwareName, tblComputers.Domain, tblComputers.Username
Order By tblSoftware.softwareName
