‎10-23-2014 10:47 PM
Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblAssets.OScode,
tblAssets.SP,
tblAssets.IPAddress As IP,
tblAssetCustom.Location,
tblAssetCustom.Department,
tblAssets.Description,
tblAssets.Lastseen,
tblAssetCustom.State
From tblAssets
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssets.AssetID In (Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%Citrix%') And tblAssets.Lastseen <>
'' And tblAssetCustom.State = 1 And tblAssets.Assettype = -1
Order By tblAssetCustom.Location,
tblAssets.OScode,
tblAssetCustom.Department
Solved! Go to Solution.
‎10-23-2014 11:32 PM
SELECT Top 1000000
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblAssets.OScode,
tblAssets.SP,
tblAssets.IPAddress As IP,
tblAssetCustom.Location,
tblAssetCustom.Department,
tblAssets.Description,
tblAssets.Lastseen,
tblAssetCustom.State,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion
FROM
tblAssets
INNER JOIN tsysAssetTypes ON tsysAssetTypes.AssetType = tblAssets.Assettype
INNER JOIN tblAssetCustom ON tblAssets.AssetID = tblAssetCustom.AssetID
INNER JOIN tblSoftware ON tblAssets.AssetID = tblSoftware.AssetID
INNER JOIN tblSoftwareUni ON tblSoftwareUni.SoftID = tblSoftware.softID
WHERE
tblAssets.Assettype = -1
AND tblAssets.Lastseen <> ''
And tblAssetCustom.State = 1
And tblSoftwareUni.softwareName LIKE '%Citrix%'
ORDER BY
tblAssetCustom.Location,
tblAssets.OScode,
tblAssetCustom.Department
‎10-23-2014 11:32 PM
SELECT Top 1000000
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblAssets.OScode,
tblAssets.SP,
tblAssets.IPAddress As IP,
tblAssetCustom.Location,
tblAssetCustom.Department,
tblAssets.Description,
tblAssets.Lastseen,
tblAssetCustom.State,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion
FROM
tblAssets
INNER JOIN tsysAssetTypes ON tsysAssetTypes.AssetType = tblAssets.Assettype
INNER JOIN tblAssetCustom ON tblAssets.AssetID = tblAssetCustom.AssetID
INNER JOIN tblSoftware ON tblAssets.AssetID = tblSoftware.AssetID
INNER JOIN tblSoftwareUni ON tblSoftwareUni.SoftID = tblSoftware.softID
WHERE
tblAssets.Assettype = -1
AND tblAssets.Lastseen <> ''
And tblAssetCustom.State = 1
And tblSoftwareUni.softwareName LIKE '%Citrix%'
ORDER BY
tblAssetCustom.Location,
tblAssets.OScode,
tblAssetCustom.Department
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now