You can create a new Event Filter by using an existing filter as a template. Event filter templates allow you to more efficiently create multiple filters against the same instance, database, application, or SQL Server login. You can also use event filter templates to apply consistent filter criteria across multiple instances and databases. When you choose to use an Event Filter as a template, IDERA SQL Compliance Manager copies the existing filter criteria to the new filter. You can then use the Edit Event Filter wizard to customize the new filter.
To use an Event Filter as a template:
- Navigate to Event Filters in the Administration tree.
- In the Event Filter tab, select the filter you want to use as a template, and then click Use as Filter Template, on the Actions ribbon.
- On each wizard window, specify the criteria you want to use for this new filter, and then click Next.
- On the Finish Event Filter window, specify a name and description for this filter, review the summary, and then click Finish. By default, the new filter is enabled.