Network Management
Last Boot Time Missing or NULL for WMI Node in SolarWinds Self-Hosted Platform
This article discusses an issue where Last Boot field is empty on the Node Details Widget for a Windows node monitored via WMI.
First published date
Last published date
Overview
This article addresses an issue where the Last Boot Time for a Windows node monitored via WMI in SolarWinds appears as Null or Empty.
Product section
Cause
- The poller entry is N.Uptime.WMI.XP which is not applicable for some Windows nodes
ErrorCode=5
ErrorMessage=Cannot retrieve data from 'X.X.X.X' at namespace 'root\CIMV2'
Query: select SystemUpTime from Win32_PerfFormattedData_PerfOS_System
Querying the class using wbemtest may also return Invalid class.
Resolution
1. Ensure the Node is Managed
Check whether the affected node is Unmanaged.
Steps:
-
Go to Web Console > Settings > Manage Nodes
-
Select Group by → ADM Status
-
Expand Unmanaged
-
If the affected node appears there:
-
Select the node
-
Go to Maintenance → Manage
-
After re-managing, wait for the next polling cycle.
2. Check Poller Configuration in the Database
If the node is already managed, verify whether it is using N.Uptime.WMI.XP or N.Uptime.WMI.Generic.
Steps:
-
Open Database Manager
-
Run the following query to locate the pollers assigned to the node::
SELECT TOP 1000 *
FROM Pollers
WHERE PollerType LIKE '%N.Uptime.WMI%' AND NetObjectID = <NodeID>;
-- 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.
-
If you see N.Uptime.WMI.XP, this poller should be replaced.
Update Poller Type
Option A: Using Database Manager (Recommended)
-
In Database Manager, click Enable Table Editing
-
Locate the record where:
-
PollerType = N.Uptime.WMI.XP
-
-
Change the value to:
N.Uptime.WMI.Generic
-
Save changes.
Option B: Using SQL Queries:
- Create a Backup of the Database.
- Connect to the SolarWinds Platform server.
- Open Database Manager from the SolarWinds Platform folder of the start menu.
- Select Add Orion Server and expand the SQL server in bold.
- Right-click the SolarWindsOrion database and select New Query.
- Paste the SQL query below into the window on the right and select Execute query:
UPDATE Pollers
SET Enabled = 1
WHERE NetObjectID = <NodeID>
AND PollerType = 'N.Uptime.WMI.Generic';
UPDATE Pollers
SET Enabled = 0
WHERE NetObjectID = <NodeID>
AND PollerType = 'N.Uptime.WMI.XP';
-- 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.