The Login Filtering Options window allows you to set login filtering. Login filtering reduces the number of login events stored in your audit data. When login filtering is enabled, the Collection Server searches the trace files sent by the SQLcompliance Agent for duplicate logins that occurred within the specified time period. Duplicate logins are logins with matching user, application, or host names. The Collection Server consolidates these logins into a single event entry in your audit data.

Login filtering is enabled when you audit login events on specific SQL Server instance. By default, the Collection Server searches for duplicate events with time stamps that are within an hour of each other.

Use login filtering to better audit login activity on SQL Server instances where applications, such as SQL Server 2005 Enterprise Studio, frequently open and close connections to SQL Server.

To set login filtering, select the provided checkbox, and specify the appropriate time period.

 

SQL Compliance Manager audits all activity on your server. Learn more > >
  • No labels