Security and Compliance framework


Job details

Name: Security and Compliance framework
Platform: Sqlserver
Category: Security
Premium package: Security and compliance package
Description: dbWatch Security framework job. Used for collecting and analysis of statistics from all Security jobs.
Long description: dbWatch Security framework job. Used for collecting and analysis of statistics from all Security jobs.
Version: 1.33
Default schedule: 0 2 * *
Requires engine install: Yes
Compatibility tag: .[type=‘instance’ & databasetype=‘sqlserver’]/instance[maj_version > ‘2005′ & hasengine=‘YES’ & engine_edition = ‘Microsoft SQL Server’]

Parameters

Name Default value Description
return status 0 Return status value (ALARM – 2, WARNING – 1, or OK – 0) when any issues of security compliance are detected. Regardless of status, the individual jobs are returning.
return status when changes occur 0 Return status value (ALARM – 2, WARNING – 1, or OK – 0) when any changes of security compliance issues are detected. Regardless of status, the individual jobs are returning.
history threshold 365 The maximum number of days to keep statistics for in the historic tables.

Job Summary

SELECT TASK_ID, NAME, SC_STATUS, STATUS, LAST_RUN FROM dbw_security_framework_info ORDER BY LAST_RUN DESC;

Job Operations

Dependencies and System Requirements

The operation of this job relies on specific tables and procedures within the database, such as:

Execution Details

Reporting

Report Component Description
Security and Compliance framework presentation Displays detailed statistics, compliance issues, and execution details of security jobs.
Issues and compliance history Show historical data and the number of detected issues over time, providing trends and patterns.

Customized Elements

Error Handling and Remarks

Through these stringent and detailed monitoring and evaluation processes, dbWatch ensures robust security compliance adherence and provides databases with the necessary tools to manage and mitigate risk efficiently.