We can access the Rule and Audit logs on the MC. The statistics provided within these reports are somewhat basic. Based on what we can see we can access the data we need within the Surveillance DB. My question is, does anyone know of any SQL queries we can run to pull this kind of data into a workable form? Essentially we need to be able to determine the below
Operator Name
Signal ID
Time Alarm was viewed
Reason for closing (we have that configured)
Amount of alarms in the “new” stack at the time of the signal in question
Alarm lifespan (time alarm was on in the “new” stack)