cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
tomecheq
Engaged Sweeper
Hello,

I have problem with astest state.
Some assets state is changed automatically to non-active despite that they are online all the time (some fibre switches, servers ILO, printers ).
Devices are in separated VLAN's but traffic is allowed between lansweeper server network and devices network.
I have manually change status to active but after few days it was set again to non-active.

I have noticed it after installing actual version:
Current Version:
Website Version: 5081
MGMT 5.0.0.81
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Assets can only automatically be set to non-active by the cleanup options found in the web console under Configuration/Scanning Setup/Server Options. These cleanup options only affect Windows computers. There are NO cleanup options for non-Windows machines in Lansweeper 5.0.

Someone either manually set the non-Windows machines to non-active on their Lansweeper webpages or ran a database script to do so. There is no other explanation. You can run the script below in the Lansweeper web console under Configuration/Scanning Setup/Database Scripts to reactivate any non-Windows machines that were successfully scanned in the last 3 days. Copy and paste the code and hit the Execute SQL Code button. We recommend performing a database backup before executing any scripts.
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)

View solution in original post

3 REPLIES 3
Hemoco
Lansweeper Alumni
Assets can only automatically be set to non-active by the cleanup options found in the web console under Configuration/Scanning Setup/Server Options. These cleanup options only affect Windows computers. There are NO cleanup options for non-Windows machines in Lansweeper 5.0.

Someone either manually set the non-Windows machines to non-active on their Lansweeper webpages or ran a database script to do so. There is no other explanation. You can run the script below in the Lansweeper web console under Configuration/Scanning Setup/Database Scripts to reactivate any non-Windows machines that were successfully scanned in the last 3 days. Copy and paste the code and hit the Execute SQL Code button. We recommend performing a database backup before executing any scripts.
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)
Hemoco
Lansweeper Alumni
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.
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.


It is not possible that someon is changing state for devices because i have only access to do it 🙂


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.

Windows computer are ok.


New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now