Windows: Installed web browsers (Built-in)

[Nick_VDB]

Added in v.6.0.100

The report below lists Windows computers and which of the predefined web browsers are installed on the computer. The report checks for Internet Explorer, Mozilla Firefox, Google Chrome, Safari and Opera.

The report will only list assets that meet all of the following criteria:

• The computer's state is set to "active".
  
• The computer has been successfully scanned at least once
  
• The asset is a Windows computer.
  

Select Distinct Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tsysOS.OSname As OS,
  tblAssets.SP,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  Case When Chrome.softID Is Null Then '-' Else 'Installed' End As Chrome,
  Case When Edge.AssetID Is Null Then '-' Else 'Installed' End As Edge,
  Case When FireFox.softID Is Null Then '-' Else 'Installed' End As Firefox,
  Case When InternetExplorer.softID Is Null Then '-' Else 'Installed'
  End As InternetExplorer,
  Case When Opera.softID Is Null Then '-' Else 'Installed' End As Opera,
  Case When Safari.softID Is Null Then '-' Else 'Installed' End As Safari
From tblAssets
  Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tsysIPLocations On tsysIPLocations.LocationID =
    tblAssets.LocationID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Left Join (Select tblSoftware.AssetID,
    tblSoftware.softID
  From tblSoftware
    Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
  Where tblSoftwareUni.softwareName Like 'Windows Internet Explorer%')
  As InternetExplorer On InternetExplorer.AssetID = tblAssets.AssetID
  Left Join (Select tblSoftware.AssetID,
    tblSoftware.softID
  From tblSoftware
    Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
  Where tblSoftwareUni.softwareName Like '%Mozilla Firefox%') As FireFox
    On FireFox.AssetID = tblAssets.AssetID
  Left Join (Select tblSoftware.AssetID,
    tblSoftware.softID
  From tblSoftware
    Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
  Where tblSoftwareUni.softwareName Like '%Google Chrome%') As Chrome
    On Chrome.AssetID = tblAssets.AssetID
  Left Join (Select tblSoftware.AssetID,
    tblSoftware.softID
  From tblSoftware
    Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
  Where tblSoftwareUni.softwareName Like '%Safari%') As Safari
    On Safari.AssetID = tblAssets.AssetID
  Left Join (Select tblSoftware.AssetID,
    tblSoftware.softID
  From tblSoftware
    Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
  Where tblSoftwareUni.softwareName Like 'Opera%') As Opera On Opera.AssetID =
    tblAssets.AssetID
  Left Join (Select Top 1000000 tblFileVersions.AssetID
  From tblFileVersions
  Where
    tblFileVersions.FilePathfull Like
    '%\SystemApps\Microsoft.MicrosoftEdge_8wekyb3d8bbwe\MicrosoftEdge.exe' And
    Case tblFileVersions.Found When 0 Then 'No' When 1 Then 'Yes'
    End = 'Yes') Edge On Edge.AssetID = tblAssets.AssetID
Where tblState.Statename = 'Active' And tsysAssetTypes.AssetTypename In
  ('Windows', 'Windows CE')
Order By tblAssets.Domain,
  tblAssets.AssetName