We have been testing things out by triggering the alarms in the PLC program and generating some reports based on these alarms by querying the alarmlog table. When we get done testing and are ready to go live with the system, what is the preferred way of purging all the old logged data? Is it as simple as doing a truncate on the alarmlog table or will that break things?
Yes, you can just delete the data from the table. A “DELETE FROM alarmlog” query or similar would be fine.
FactorySQL doesn’t rely on anything being in the log or status table, or assume that data will be there.