FunctionsAndProcedures - SteveStedman/SqlForensics GitHub Wiki

[ForensicLogging].[getLogTypeId]

Internal stored used to get an ID associated with the type of item being logged. If the log item doesn't exist it gets added.

[ForensicLogging].[monitorConfig]

Monitors for any changes to configuration settings. Anything that can be set with sp_configure is monitored in this stored procedure.

This is called from [ForensicLogging].[runFullMonitoringPass] but it could be called directly if you just wanted to monitor the configuration without monitoring other options.

[ForensicLogging].[monitorUsers]

Keeps track of any added or changed users on the system.

This is called from [ForensicLogging].[runFullMonitoringPass] but it could be called directly if you just wanted to monitor users without monitoring other options.

[ForensicLogging].[monitorObjects]

Keeps track of any stored procedures, functions, or triggers that have been changed.

This is called from [ForensicLogging].[runFullMonitoringPass] but it could be called directly if you just wanted to monitor objects without monitoring other options.

[ForensicLogging].[getSetting]

See Optional Settings for more details.

[ForensicLogging].[setSetting]

See Optional Settings for more details.

[ForensicLogging].[runFullMonitoringPass]

This is the stored procedure that should be scheduled as a regular job EXECUTE [ForensicLogging].[runFullMonitoringPass] ;