LANSweeper : Identify Non-standard Browsers

LANSweeper : Identify Non-standard Browsers

The following query, when copied into the report designer, will identify computers with non-standard browsers – i.e. users with browsers other than Internet Explorer. Adjust this to suit your environment, corporate standards are different everywhere.

{code lang:sql showtitle:false lines:false hidden:false}Select Top 1000000 tblComputers.ComputerName,tblComputers.ComputerUnique,tblSoftware.softwareNameAsProduct, tblComputers.Domain,tblComputers.Username

From tblSoftware
Inner Join tblComputers On tblSoftware.ComputerName=tblComputers.Computername
Inner Join web40ActiveComputers On tblComputers.Computername=web40ActiveComputers.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{/code}