Page History

You can manually remove the clear events from the PROTOCOL table using SQL queries as followsin the following way:

1. Shut down Axxon PSIM if it is running.
2. Determine the events which should be removed that you want to remove from the events database.
3. Open the Axxon PSIMmain.ddi file using the ddi.exe configuration settings utility (see The ddi.exe utility for editing database templates and external settings file):
   1. select Select the object of the whose events from which you want to delete;.
   2. go Go to the Events tab to view the names of the removed events to be deleted in the database.

4. In SQL Server Management Studio, run a the query to remove the selected events:

   Code Block
   delete FROM [Axxon PSIM].[dbo].[PROTOCOL] where action = 'action' where [Axxon PSIM].[dbo].[PROTOCOL] — is the name of the table with events; action — is the name of the event to be deleted in the database.

As a result, the selected events will be are removed from the PROTOCOL table using an the SQL query.

For example, if it is necessary you want to remove all the all Alarm events of the Camera object, then do the following:

1. In the Axxon PSIMmain.ddi file, select the Cam object (1).
   
2. Go to the Events tab (2).
3. Find the name of the removed Alarm event to be deleted in the database: in the MD_START (3) database.

4. In SQL Server Management Studio, run the query:

   Code Block
   delete FROM [Axxon PSIM].[dbo].[PROTOCOL] where action = 'MD_START'

As a result, the the Alarm camera events from cameras will be are removed from the events table.

...