‎10-28-2013 11:30 AM
Solved! Go to Solution.
‎11-04-2013 02:00 PM
UPDATE tblassetcustom
SET state = 1
WHERE EXISTS (SELECT 1
FROM tblassets AS assettable
WHERE assettable.assetid = tblassetcustom.assetid
AND assettable.assettype <> -1 AND assettable.lastseen > GetDate() - 3)
‎11-04-2013 02:00 PM
UPDATE tblassetcustom
SET state = 1
WHERE EXISTS (SELECT 1
FROM tblassets AS assettable
WHERE assettable.assetid = tblassetcustom.assetid
AND assettable.assettype <> -1 AND assettable.lastseen > GetDate() - 3)
‎10-30-2013 06:10 PM
‎10-31-2013 10:41 AM
Lansweeper wrote:
In Lansweeper 5.0, non-Windows machines can only be set to non-active manually. If a non-Windows machine is set to non-active, someone manually changed its state, either on the device's asset page or by running a custom database script.
For your Windows machines, please check the cleanup options you have enabled under Configuration/Scanning Setup/Server Options. These determine which Windows computers are set to non-active.
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now