Using the excellent info provided in this thread (https://thwack.solarwinds.com/docs/DOC-129094#start=100 ) I've been monitoring APC UPS's quite nicely for the last few years.
But recently I've noticed a few APC SmartUPS (model 8000's) have local alerts showing the batteries need to be replaced, while NPM (which is monitoring these UPS's) does not show them in the expected window (below).
Any ideas what we're missing to make this happen? One of the affected UPS's is an APC Smart-UPS 8000. It should show up in the Widget / Resource below, but does not.
The custom Resource I've built for the front page of my NPM that not showing these UPS's need batteries is built as follows:
That resource uses the following SQL Datasource1 query:
SELECT
N.NODEID,
N.CAPTION AS 'DEVICE',
N.LOCATION AS 'LOCATION',
CPS.STATUS AS 'CURRENT STATUS',
CPS.DATETIME AS 'LAST POLLED'
FROM NODES N
JOIN CUSTOMPOLLERASSIGNMENT CPA ON N.NODEID = CPA.NODEID
JOIN CUSTOMPOLLERSTATUS CPS ON CPA.CUSTOMPOLLERASSIGNMENTID =
CPS.CUSTOMPOLLERASSIGNMENTID
WHERE CPA.CUSTOMPOLLERID IN (SELECT CUSTOMPOLLERID FROM CUSTOMPOLLERS WHERE
UNIQUENAME = 'UPSADVBATTERYREPLACEINDICATOR')
AND CPS.STATUS = 'batteryNeedsReplacing'
ORDER BY CPS.STATUS, N.LOCATION, N.CAPTION
The UPS's were not configured to send traps to Orion and that has been corrected.
Still, some APC UPS's need new batteries and are sending that trap to NPM, but are not showing up in the expected UPS Battery Replacement Widget.
