Querying alarm occurences

Hello,

I am using Ignition 7.7.8 version. We are using ignition alarm management to generate alarm notification emails based on tag value changes. I understand that I can use an alarm status table available in the ignition designer to display list of all alarms. But what I want to do is to be able to query occurrences of specific alarms - whether acknowledged and shelved or not. Is there any way for me to query the database to filter out and count the alarm conditions over a large period of time - say 1 year or so?

Thanks,

Shreyas