Database help

I'm using an Excel addin to pull alarms from a scada system. There are over 200 alarms being pulled in 15 min intervals. I want to organize the active alarms in a timeline summary. I'm not sure how to go about pulling the active alarms from the query.