Database profiles in SCM

Server Configuration Monitor (SCM) offers a number of out-of-the-box database profiles. See the table below for compatible versions and a comparison of the information you can track in each database profile type:

	MS SQL Server Essentials	PostgreSQL Essentials	MySQL Essentials
Versions of database software that are compatible with SCM out-of-the-box profiles	MS SQL 2012 and later	PostgreSQL 12.1 PostgreSQL 11.6 PostgreSQL 10.11 PostgreSQL 9.6.16 PostgreSQL 9.5.20 PostgreSQL 9.4.25	MySQL 8.0 MySQL 5.7
Global	Configuration registry entries Query optimizer hotfixes Instant file initialization Server configuration Server properties SSIS packages	Server settings Time zones Collations	Version information Global variables Character sets and collations
Server configuration	Linked servers Database files Database mail Database options Default data and log location TempDB	Publications Configuration files	Engines Plugins
DB Schema	Filegroups Tables Columns Views Indexes Triggers Stored procedures System database objects	Databases Tablespaces Tables Views Attributes (Columns) Indexes Procedures and functions	Databases (schemata) Tablespaces Tables Columns Views Table constraints Triggers Routines Routine parameters
Users and privileges	Logins Permissions Security Suspect pages	Database roles Authentication rules Users	Administrable role authorization Enabled roles Database privileges (schema) Table privileges User privileges Column privileges Role table grants Role column grants Role routine grants
Events and jobs	SQL agent jobs		Events
Backup and recovery, mirroring	Database backup Recovery mode Mirroring High availability	Subscriptions
Policy	Policy management