We have bunch of digital alarm tags, (15k +) and I'm trying to figure out an easy way to show the top 10 alarms over a time period. For example, what alarms occurred the most often over the last month. I'm considering using AF and event frames but I'm afraid that it would bog down the system, its not uncommon to have several hundred thousand alarms per month. I was also considering writing an ACE program to comb over the data and produce the results but it seems like there should be an easier way to be a frequency distribution.
Any thoughts from anybody?