Default trace enabled


Job details

Name: Default trace enabled
Platform: Sqlserver
Category: Security
Premium package: Security and compliance package
Description: Checks that ‘Default Trace Enabled’ server configuration option is set to ‘1′.
Long description: Checks that ‘Default Trace Enabled’ server configuration option is set to ‘1′. The default trace provides audit logging of database activity including changing of accounts and privileges.
Version: 1.2
Default schedule: 9 1 1 *
Requires engine install: Yes
Compatibility tag: .[type=‘instance’ & databasetype=‘sqlserver’]/instance[maj_version > ‘2005′ & hasengine=‘YES’ & eng_inst_priv = 0 & (engine_edition = ‘Microsoft SQL Server’ engine_edition = ‘Azure SQL Managed Instance’)]

Parameters

Name Default value Description
return status 1 Return status value (ALARM – 2, WARNING – 1, or OK – 0) if the instance is exposed by SQL Browser (for Non-clustered SQL Server instances).
enable default trace NO If set to “YES“ the alert will enable “default trace enabled” by running sp_configure stored procedure.
history threshold 365 The maximum number of days to keep statistics for in the historic tables.

Job Summary

SELECT value_in_use FROM sys.configurations WHERE name = 'default trace enabled';

Dependencies and Structure

Job Implementation

Reporting

Automation and Maintenance