
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-28-2012 05:11 PM
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
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-17-2014 08:15 PM
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. 🙂
4 REPLIES 4
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-17-2014 08:15 PM
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. 🙂

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-17-2014 06:24 PM
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?


Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-29-2012 11:56 PM
Worked great! Thank you very much!


Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-29-2012 05:01 PM
Please try the report below.
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.
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.
