Network Management

Last Boot value is incorrect in SolarWinds Platform

The Node's Last boot value is incorrect. The node's last reboot time is incorrect, as is the Orion agent's last reboot time.

First published date

8/27/2020 3:10 PM

Last published date

3/29/2022 5:13 PM

Overview

SolarWinds collect Last Boot time from nodes. For numerous reasons, this value sometimes is stuck with an old value. 



Upon checking the server directly, it can be seen this value is incorrect.


(Screenshots property of Microsoft ©2022/09/02 Microsoft)

When this issue occurs, it is advised to clear it from the database.

Product section

Orion Platform

Resolution

Log in to the Orion server. Any polling engine.
  1. Open Database Manager.
  2. Run the following after determining the correct node.  
    -- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

UPDATE [dbo].[NodesStatistics]
SET LastBoot = '', SystemUpTime = ''
WHERE NodeID = XXXX

--WHERE XXXX is your NodeID with the stale LastBoot value.
  3. Unmanage the Device for 2 minutes, then re-manage it. This will cause the system to recalculate the Lastboot value.