Need to find all installations of Firefox and Chrome

[jeffreyl]

Does anyone have a report that will find all versions of Google Chrome and Mozilla Firefox? I would love to have a default report of all installed web browsers. Thanks

[RCorbeil · Accepted solution]

SELECT Top 1000000
  tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblSoftwareUni.softwareName,
  tblSoftware.softwareVersion,
  tblSoftwareUni.SoftwarePublisher,
  tblSoftware.Installdate,
  tblSoftware.Lastchanged
FROM
  tblAssets
  INNER JOIN tblAssetCustom ON tblAssets.AssetID = tblAssetCustom.AssetID
  INNER JOIN tsysAssetTypes ON tsysAssetTypes.AssetType = tblAssets.Assettype
  INNER JOIN tblSoftware ON tblAssets.AssetID = tblSoftware.AssetID
  INNER JOIN tblSoftwareUni ON tblSoftwareUni.SoftID = tblSoftware.softID
WHERE
  tblAssetCustom.State = 1
  AND (    (tblSoftwareUni.softwareName LIKE '%Firefox%'       AND tblSoftwareUni.SoftwarePublisher LIKE '%Mozilla%')
        OR (tblSoftwareUni.softwareName LIKE '%Google Chrome%' AND tblSoftwareUni.softwareName NOT LIKE '%Google Chrome Frame%')
        OR (tblSoftwareUni.softwareName LIKE '%Opera%'         AND tblSoftwareUni.SoftwarePublisher LIKE '%Opera%')
        OR (tblSoftwareUni.softwareName LIKE '%Safari%'        AND tblSoftwareUni.SoftwarePublisher LIKE '%Apple%'))
ORDER BY
  tblSoftwareUni.softwareName,
  tblSoftware.softwareVersion,
  tblAssets.AssetName

Includes checks for Safari and Opera at no extra charge. 🙂

[Malbanese]

I tried this report and got an error, then I saw that it was posted in 2012. Is there an updated version of this report?

[jeffreyl]

Worked great! Thank you very much!

[Hemoco]

Please try the report below.

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblSoftware.softwareName, tblSoftware.softwareVersion,
tblSoftware.SoftwarePublisher, tblSoftware.Installdate,
tblSoftware.Lastchanged
From tblComputers Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Where (tblSoftware.softwareName Like '%firefox%') Or
(tblSoftware.softwareName Like '%chrome%')
Order By tblSoftware.softwareName, tblSoftware.softwareVersion,
tblComputers.ComputerUnique

To use the specified report, do the following:
• Open the Lansweeper configuration console and select Reports & Alerts\Report Builder. Hit the “New” button.
• Copy the SQL code provided and paste it at the bottom of the newly created report, replacing the default SQL code.
• Click somewhere near tblComputers so the new code applies.
• Give the report a “View name” and a “Report name” and hit the “Save” button.
• Double-click on the report in the report list to see its results and export options.