cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
jeffreyl
Engaged Sweeper
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
1 ACCEPTED SOLUTION
RCorbeil
Honored Sweeper II
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. 🙂

View solution in original post

4 REPLIES 4
RCorbeil
Honored Sweeper II
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
Engaged Sweeper III
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
Engaged Sweeper
Worked great! Thank you very much!
Hemoco
Lansweeper Alumni
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.