Happy New Year all!
I have a small issue I am looking for some advice on.
Within NPM, we have some Network Hardware which SolarWinds doesn’t poll the VPN status’s within the usual ‘List Resources’ option. After creating some Custom Pollers, I now have the data I need and I have been able to create an alert which references the Custom Poller data (e.g. VPN status = Down).
Within the Alert body, I have added some SWQL statements (one for each VPN status, and one for the Serial Number of the device) however, when simulating the alert I seem to get data for another node (i.e. a different device Serial Number and VPN status), probably the first listing in the table results.
Is there a way I can reference the alerting host ID into the SWQL statement allowing the correct custom poller data to be included in the message body?
The Alert body in its current form looks like this:
Device Name: ${N=SwisEntity;M=Node.Caption}
Device IP: ${N=SwisEntity;M=Node.IP_Address}
Device Serial Number: ${N=SWQL;M=SELECT
Status As [SerialNumber]
FROM Orion.NPM.CustomPollerStatusOnNode
WHERE AssignmentName LIKE 'CitrixsdWANApplianceSerialNumber%'
}
VPN1: ${N=SWQL;M=SELECT Status
FROM Orion.NPM.CustomPollerStatusOnNode
WHERE AssignmentName LIKE 'sdWANStatsvPathState%' AND RowID = '1'
}
VPN2: ${N=SWQL;M=SELECT Status
FROM Orion.NPM.CustomPollerStatusOnNode
WHERE AssignmentName LIKE 'sdWANStatsvPathState%' AND RowID = '2'
}
Custom Poller Name: ${N=SwisEntity;M=CustomPoller.UniqueName}
Polled OID: ${N=SwisEntity;M=CustomPoller.OID}
Poller Table Current Value: ${N=SwisEntity;M=Status}
