→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎08-18-2014 08:02 PM
Solved! Go to Solution.
‎08-19-2014 03:00 PM
SELECT s.AssetName, s.AssetID, tsysAssetTypes.AssetTypeIcon10 AS Icon, s.IPAddress AS [IP Address], tblAssetCustom.Manufacturer, tblAssetCustom.Model,
tblAssetCustom.Location, s.Lastseen
FROM tblAssets AS s INNER JOIN
tblAssetCustom ON tblAssetCustom.AssetID = s.AssetID INNER JOIN
tsysAssetTypes ON s.Assettype = tsysAssetTypes.AssetType INNER JOIN
tblState ON tblAssetCustom.State = tblState.State
WHERE (NOT EXISTS
(SELECT ChildAssetID
FROM tblAssetRelations AS r
WHERE (Type = 14) AND (ChildAssetID = s.AssetID)))
ORDER BY s.AssetName
‎08-28-2014 12:59 AM
‎08-19-2014 03:00 PM
SELECT s.AssetName, s.AssetID, tsysAssetTypes.AssetTypeIcon10 AS Icon, s.IPAddress AS [IP Address], tblAssetCustom.Manufacturer, tblAssetCustom.Model,
tblAssetCustom.Location, s.Lastseen
FROM tblAssets AS s INNER JOIN
tblAssetCustom ON tblAssetCustom.AssetID = s.AssetID INNER JOIN
tsysAssetTypes ON s.Assettype = tsysAssetTypes.AssetType INNER JOIN
tblState ON tblAssetCustom.State = tblState.State
WHERE (NOT EXISTS
(SELECT ChildAssetID
FROM tblAssetRelations AS r
WHERE (Type = 14) AND (ChildAssetID = s.AssetID)))
ORDER BY s.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now