SWQL for acknowledged alerts


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