Managing the deletion of logs

Depending on the configuration of your security policies and the desired amount of logs, the log database can grow very quickly. There are various tools allowing you to delete logs and prevent the database from being saturated:

  • Monthly deletion of system and agent logs that have exceeded the specified retention duration.

  • Daily deletion of agent logs based on the specified criteria, performed by the maintenance task. For further information, refer to the section Configuring daily maintenance tasks.

  • Manual deletion of agent logs.

System and agent logs are kept by default for 12 months, or 2 months if you use SQL Server Express. The oldest logs will be deleted. These values can be changed.

  1. Select the Backoffice > System menu and click on the Log database tab.

  2. In the upper banner, click on Edit.

  3. In the section Monthly deletion of logs, choose how long (in months) you wish to keep agent events and system logs. After this duration expires, they will be deleted by an automatic task once a month.

To keep logs forever, disable monthly deletion by switching off the button. Log deletion cannot be disabled if you use SQL Server Express.

You can configure rules to delete logs daily. Every day, the maintenance task will check the criteria specified in the rules and delete logs that match all criteria:

To configure a rule to delete logs:

  1. Select the Backoffice > System menu and click on the Log database tab.

  2. In the upper banner, click on Edit.

  3. In Daily deletion of agent logs, click on Add a rule.
    The Add a daily rule window will appear.

  4. Specify the criteria for deleting logs:

    Date

    You can choose whether to delete logs before a specific date, or delete all logs regardless of date.
    Severity

    You can select the log levels to be deleted. Refer to the section Managing logs.
    Status You can select the log statuses to be deleted. Refer to the section Managing logs.

    Agent groups

    (optional)

    Select the agent groups for which you wish to delete logs. By default, all agent groups are concerned.

  5. Click on OK. The log deletion rule appears in the table.

  6. If necessary, disable one or several rules by unselecting the Status checkbox to the left of the table. Click on Hide disabled rules to remove them from the table. The rules will be executed every day during the maintenance task. The results of the latest execution appear in the Last result column.

If necessary, you can occasionally delete agent logs manually based on certain criteria.

  1. Select the Backoffice > System menu and click on the Log database tab.

  2. In the upper banner, click on Edit.

  3. In Manual deletion of agent logs, click on Configure and start manual deletion.
    The Add a manual rule window will appear.

  4. Specify the criteria for deleting logs:

    Date Choose the logs you wish to delete by age (in days/months) or by date.
    Severity

    You can select the log levels to be deleted. Refer to the section Managing logs.
    Status You can select the log statuses to be deleted. Refer to the section Managing logs.

    Agent groups

    (optional)

    Select the agent groups for which you wish to delete logs. By default, all agent groups are concerned.
    Agents
    (optional)    		 Select the agents for which you wish to delete logs, then select them. By default, all pool agents are concerned.
  5. Click on Estimate volume at the bottom on the right to show the volume of logs that will be deleted.
  6. Click on Start.
    All logs that meet the specified criteria will be deleted. The results of the latest execution appear in the Last result column.

    NOTE
    The space freed up after the manual deletion will be shown in the Database size supervision and estimate chart only after the next maintenance task.

  7. Click on Run manual deletion again to delete logs based on the same criteria used in the previous delete operation.