‎09-09-2020 02:22 PM
‎09-10-2020 08:20 AM
‎09-09-2020 04:51 PM
SELECT a.assetid,
assetname,
domain,
lastseen,
assettypeicon10 AS icon
FROM tblassets a
INNER JOIN tblPortableBattery Pb ON pb.assetid = a.assetid
INNER JOIN tsysassettypes at ON at.assettype = a.assettype
WHERE lastseen < GETDATE() - 1
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now