SolarWinds Farm x 16 Pollers - WMI Polling Fails/Stops ALERT

bootneck1111

Hi Guys

We are experiencing 'Last WMI Polling' issues on SW Pollers, whilst we investigate the root cause through logs I would like to create a simple alert that tells me when the WMI Poll stops on any of the SolarWinds Pollers without having to keep a constant eye on the SW Health Dashboard. Alert to be set so that If the 'Last WMI Poll' is (for example) more than '4 mins ago' then to Alert the SolarWinds Team, we can then force the poll via 'Poll Now' on the Poller/Node.

Environment:

1 x Orion Primary Polling Engine

14 x APE (Additional Polling Engines)

sreenathmp

I think you can use the field LastSystemUpTimePollUtc. Try modifying the below one.

SELECT
NodeID as NodeID,
SysName as Hostname,
IP_Address as 'IP Address',
LastSystemUpTimePollUtc as LastPoll,
VendorIcon as Vendor,
EngineID as Poller,
ObjectSubType as PollingMethod

FROM
Nodes

WHERE
LastSystemUpTimePollUtc < DATEADD( hour, -25, GETUTCDATE()) AND status = 1
order by LastPoll ASC