For last few days, I'm trying to find best way to display SNMP (and possibly other) traps.
It looks that triggers & events (alarms) are not the best way to handle it.
The only way to show most of the traps is to create trigger for every possible trap, but even in this case duplicated traps will be lost, as they are not changing any value.
I see few solutions:
- Create new table containing just traps and add additional simple view
- Create traps table and use union to mix it with alarms
- Create additional table with traps descriptions and use alarms table to keep alarms from triggers and traps.
What do you think about it ?
It looks that triggers & events (alarms) are not the best way to handle it.
The only way to show most of the traps is to create trigger for every possible trap, but even in this case duplicated traps will be lost, as they are not changing any value.
I see few solutions:
- Create new table containing just traps and add additional simple view
- Create traps table and use union to mix it with alarms
- Create additional table with traps descriptions and use alarms table to keep alarms from triggers and traps.
What do you think about it ?