Export to SQL

Export to SQL enables you to export items directly to an SQL Server instance that is reachable by the GFI EventsManager host.

To create an export to SQL job:

1. Click Configuration tab and select Options.

2. From Configurations, right-click Database Operations node and select Create new job…

3. Click Next at the wizard welcome screen.

Creating Import\Export jobs

4. Select Import/Export Job and click Next.

Export to SQL

5. Select Export to SQL and click Next.

Specifying SQL Server details

6. Configure the following server options and click Next:

Option	Description
Server	Key in the name of the machine that is running SQL Server.
Database	Key in the name of the destination database. Note If the specified database does not exist, GFI EventsManager creates it for you.
Table	Key in the name of the destination table. Note If the specified table does not exist, GFI EventsManager creates it for you.
Use Windows authentication	Use the same logon credentials used to log on to Windows®. The SQL Server® must support this type of authentication mode to be able to connect and copy information to the server.
Use SQL Server authentication	Use the logon credentials configured in your SQL Server®. Key in the username in the User field and the password in the Password field.
Test connection	Click Test Connection to attempt to connect to the SQL Server® using the specified settings. Note GFI EventsManager tests the connection automatically after you click Next.

Select columns to export

7. Select the columns you want to export and click Next.

Filtering export data

8. Configure the following filtering options and click Next:

Option	Description
Export all events	Export all events from the database.
Events older than	Only export events older than the specified number of days/weeks/months.
Events in the last	Only export events that occurred in the last specified number of days/weeks/months.
Mark events as deleted	Hide events from the source database after they are exported. To completely remove these events from the database, you must run a Commit Deletions job. For more information refer to Commit deletions.
Advanced...	Click Advanced... to launch the Advanced Filtering dialog. This enables you to configure granular filtering parameters to export specific events only. For more information refer to Building query restrictions.

Execute job options

9. Select when the job is executed and click Finish:

Options	Description
Schedule job	The job will be saved and executed according to the database operations schedule.
Run the job now	Job is executed immediately. Unscheduled jobs only run once and cannot be reused.