Versions Compared

Old Version 1

changes.mady.by.user Evgeniya Kononova

Saved on

compared with

New Version Current

changes.mady.by.user Darya Andryieuskaya

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Note
titleAttention!

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 IntellectAxxon PSIM.
  2. Determine the events which should be removed from the events database.
  3. Open the intellectAxxon 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:

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

where

[intellectAxxon 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 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 intellectAxxon PSIM.ddi file, select the Cam object (1).
    Image Modified
  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:

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


...