Documentation for Axxon PSIM 2.0. Documentation for other versions of PSIM is available too.

Previous page Stored procedures for adding or deleting a large number of objects  Removing the event table from the Axxon PSIM database Next page


You can manually remove the events from the PROTOCOL table using SQL queries as follows:

Attention!

Once you remove the events, it cannot be undone. We recommend you to create a backup before removal (see Creating the database backup copy).

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

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

    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 removed from the PROTOCOL table using an SQL query.

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

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

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

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

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

  • No labels