top of page

SQL Audit

This optional plugin enables BusinessLog to collect Microsoft SQL Server audit logs.
Other database platforms require Syslog integration.

After enabling the licence, activate the plugin under Configuration > Plugin.

SqlServerEN_edited.jpg

After activation, SQL Server must be configured using SQL Server Management Studio.

Log in as an administrator, expand the tree on the left, and select:

Security > Audits.

Immagine1.png

Right-click Audits and select New Audit.

Immagine2.png

A custom name may be assigned to the audit if required.
Set the audit destination to Application Log, then confirm and close the window.

Immagine3.png

At this stage, audit specifications can be configured at either server level or database level.

Server Level

Immagine4.png

Select "Server Audit Specifications", then right-click > New Server Audit Specification.

Immagine5.png

Under the Audit field, select the audit previously created from the drop-down list.

Expand the window and configure the central grid according to the required server-level audit settings.

Immagine6.png

For exemple:

Immagine7.png

Consult a SQL Server specialist to determine which audit actions should be enabled at server level.

Database Level

Expand the database to be monitored and select:
Security > Database Audit Specifications

Immagine8.png

Create a new specification and associate it with the previously created audit.

Immagine9.png

Expand the configuration window and configure the central grid.

Immagine10.png

Audit controls can be defined at global (database) level or for a specific table. For example:

Immagine11.png

This configuration generates a log entry whenever a user under the dbo schema performs an INSERT operation on a specific table, such as Agents, within the current database.

  • The object class defines the audit scope, whether global, schema, or table.

  • The object name identifies the database, schema, or table to be monitored.​

Audit configurations may vary depending on security requirements. Consultation with a SQL Server expert is recommended to determine the appropriate configuration.

NOTE: Audit is disabled by default and must be explicitly enabled.

ATTENTION:

Any modification to an audit must be performed while the audit is disabled.

Once enabled, SQL audit logs are recorded in a dedicated table accessible from:

Main Menu > SQL Audit Logs.

Log Audit Sql.png

Guide

bottom of page