Database compatibility

Name:	Database compatibility
Platform:	Sqlserver
Category:	Security
Description:	Checks if there is a difference in compatibility levels of databases and the instance.
Long description:	Checks if there is a difference in compatibility levels of databases and the instance.
Version:	1.3
Default schedule:	9 1 1 *
Requires engine install:	Yes
Compatibility tag:	[CDATA[.[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
ignore databases	model	List of databases (separated by comma) which will be ignored. You can use % (percent sign) to represent wild card characters.
return status	1	Return status value (ALARM – 2, WARNING – 1, or OK – 0) when any database are in lower compatibility level than master database.
enforce compatibility	NO	If set to “YES” the alert will enforce instance compatibility for every databases by running ALTER DATABASE
history threshold	365	The maximum number of day to kept statistics for in the historic tables.

Feedback