Documentation for Intellect 4.11.0-4.11.3. Documentation for other versions of Intellect is available too.

Previous page Stored procedures for adding or deleting a large number of objects  Removing the event table from the Intellect 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 Intellect.
  2. Determine the events which should be removed from the events database.
  3. Open the intellect.ddi file using the ddi.exe utility (see The ddi.exe utility for editing database templates and external settings files):
    1. select the object 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 [intellect].[dbo].[PROTOCOL] where action = 'action'

where

[intellect].[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 intellect.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 [intellect].[dbo].[PROTOCOL] where action = 'MD_START'

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

  • No labels