Try this custom SQL report:
Nodes.NodeID AS NodeID,
StatusLED AS Status_Icon,
Status AS Status,
Nodes.Caption AS NodeName,
Nodes.VendorIcon AS Vendor_Icon,
Nodes.IP_Address AS IP_Address,
AlertStatus.TriggerTimeStamp AS "TIME OF ALERT",
AlertStatus.Acknowledged AS "Ack",
AlertStatus.AlertDefID AS "DefID"
Nodes LEFT JOIN AlertStatus ON (AlertStatus.ObjectName = Nodes.Caption)
(Nodes.Status = '2')
Order by NodeName ASC
This should meet your requirement. Please Note:
- use advanced alerts only. If use basic alert, not alert time displayed
- if you have more than one down node advanced alert, you may get duplicated results. You can add filter for "AlertStatus.AlertDefID" to remove duplicate.
- Ack: 0 no, 1 yes. You can click it to go to alert page to add ack
Hope this is useful.
Good morning, how were you able to capture time of Alert ?
Don't bother found it under AlertStatusView
I created like the same but in that list some of the events not showing.