Adding new SQL Servers to the default group

The SQL Server audit feature allows you to process the activity logs generated by day-to-day SQL Server operations such as server startup or on key events such as failed logons.

Like computers, SQL Servers can be grouped and processed using a common event-log scanning policy. To create an SQL Server group:

1. Click on the Configuration tab.

Screenshot 46 – Database Servers Groups

2. From the Group Type drop-down select Database Servers Groups.

Screenshot 47 – Add a new Microsoft SQL Server

3. In the Groups section, right click on SQL Servers and select Add new Microsoft SQL Server.

Screenshot 48 – Select Microsoft SQL Server(s)

4. Click on the Select button and choose the required Microsoft SQL Server machines from list. Click OK when selection is complete.

5. Click on the Finish button to finalize your settings.

NOTE: You cannot audit the SQL Server that is currently being used as database backend by GFI EventsManager.