Our plant is divided into rooms and in each room are cells made up of several pieces of equipment. I am working on a system to monitor each cell. We have setup SQLtags with alerts in several cells as a trial. We have also added several columns and a database trigger to the alert history table that records the current cell#, room#, and job# whenever we get an alert. We are using a machine ID code in the Display Path field to get this data from other tables.
I was able to create tables to show alarm history based on the added information but have not found a way to do this with active alarms.
Is there a way to make a Alarm Summary Table that will show just the alarms for the selected cell so that the operator can acknowledge them without seeing the alarms from the other cells?