I too am needing to get some sort of alert when a power supply goes out. Following what you did, I was able to get an alert on a test device, when I shut the power off on the secondary supply. I don't know for sure if it will work on other devices, as they are in production. It did show the device lost a power supply. When I pulled the power supply out and it was no longer in the device, I got a reset alert. So that part seems okay.
What I want to be able to do is have a report on the web view that actually shows any devices that I am monitoring power supplies on show if the are normal or not. Something that will allow me at a glance to see if there are any problems, even if an alert has gone out.
that sounds promising, thanks for sharing your test results- I also opened a case to verify that our approach is the right one...
regarding your reporting request, do you mean a PS state view area on the GUI node view like this?
Or maybe a summary report for PS status of all devices in one reporting view?
BTW: Here the Solarwinds Support answer to the tabular array alerting question:
If the Get type is a Get-Table any value within that table Orion retrieves that meets the criteria in the alert will trigger it. It check all one by one, if the variable is used in the email body you will get the whole table with the values separated by a comma, but there should be at least one meeting the trigger conditions
Maybe you look for something like that? Check it out:
, l.[Label] FanModuleLabel
, s.[Status] Status
FROM [CustomPollerStatus] s
JOIN [CustomPollerAssignment] a ON a.[CustomPollerAssignmentID] = s.[CustomPollerAssignmentID]
AND (SELECT [CustomPollerID] FROM dbo.[CustomPollers] WHERE OID = '184.108.40.206.220.127.116.11.18.104.22.168.3') = a.[PollerID]
JOIN [CustomPollerLabels] l ON l.[CustomPollerAssignmentID] = a.[CustomPollerAssignmentID] AND l.[RowID] = s.[RowID]
JOIN [Nodes] n ON n.[NodeID] = a.[NodeID]