03-28-2012 05:11 PM
Solved! Go to Solution.
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
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
06-17-2014 06:24 PM
03-29-2012 11:56 PM
03-29-2012 05:01 PM
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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now