It is currently Wed Jul 30, 2014 5:10 am




Post new topic Reply to topic  [ 2 posts ] 
 Purging old Alarms 
Author Message
Trooper
Trooper

Joined: Wed Nov 25, 2009 1:14 pm
Posts: 25
Post Purging old Alarms
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?


Fri Feb 12, 2010 8:12 am
Profile
Moderator
Moderator

Joined: Sun Apr 02, 2006 3:43 pm
Posts: 2465
Post Re: Purging old Alarms
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.

Regards,

_________________
Colby Clegg
Inductive Automation
Software Development


Fri Feb 12, 2010 1:39 pm
Profile
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to: