I am looking for a query which provide me a the following information :
- Who acknowledged the alert!
- Acknowledged / Unacknowledged alert in last 24 hours.
- This request is for all (Node ack, Application ack, Volume ack etc).
- Columns consist of Node Name, Alert Name, Alert Time, Acknowledge Time, Acknowledged By, Notes, EventType (if possible), Event Name (If possible)
Thanks in advance