Published January 26, 2022.
To show the configured triggers.
This feature queries the DMV sys.triggers which returns information for database and table triggers.
The report page Triggers has a table showing each configured trigger.
The model for the report uses the fact [Triggers] and the dimension [Database].
The feature accept the parameter @Databases and the syntax is the same that is used in the SQL Server Index and Statistics Management solution made by Ola Hallengren.
The default parameter for the feature is “@Databases = ‘USER_DATABASES, msdb'”
|SYSTEM_DATABASES||All system databases (master, msdb, model, and tempdb)|
|USER_DATABASES||All user databases|
|Db1||The database Db1|
|Db1, Db2||The databases Db1 and Db2|
|USER_DATABASES, -Db1||All user databases, except Db1|
|%Db%||All databases that have “Db” in the name|
|%Db%, -Db1||All databases that have “Db” in the name, except Db1|
|ALL_DATABASES, -%Db%||All databases that do not have “Db” in the name|
The default schedule for the feature is once every day between 22:00 and 23:00.
The default retention for the table dbo.fhsmTriggers is 30 days.