06-30-2016 06:09 PM
Solved! Go to Solution.
07-01-2016 07:51 PM
SELECT IPLocation
,RealStart
,RealEnd
,(
SELECT DISTINCT COUNT(*)
FROM tblAssets
INNER JOIN tblAssetCustom ON tblAssets.AssetID = tblAssetCustom.AssetID
WHERE tblAssetCustom.STATE = 1
AND (
tblAssets.IPNumeric >= tsysIPLocations.StartIP
AND tblAssets.IPNumeric <= tsysIPLocations.EndIP
)
) AS TotalAssets
FROM tsysIPLocations
07-04-2016 11:33 AM
07-01-2016 07:51 PM
SELECT IPLocation
,RealStart
,RealEnd
,(
SELECT DISTINCT COUNT(*)
FROM tblAssets
INNER JOIN tblAssetCustom ON tblAssets.AssetID = tblAssetCustom.AssetID
WHERE tblAssetCustom.STATE = 1
AND (
tblAssets.IPNumeric >= tsysIPLocations.StartIP
AND tblAssets.IPNumeric <= tsysIPLocations.EndIP
)
) AS TotalAssets
FROM tsysIPLocations
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now