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.
3. Click Next at the wizard welcome screen.
4. Select Import/Export Job and click Next.
5. Select Export to SQL and click Next.
6. Configure the following server options and click Next:
|Server||Key in the name of the machine that is running SQL Server.|
Key in the name of the destination database.
If the specified database does not exist, GFI EventsManager creates it for you.
Key in the name of the destination table.
If the specified table does not exist, GFI EventsManager creates it for you.
|Use Windows authentication|
|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.|
Click Test Connection to attempt to connect to the SQL Server® using the specified settings.
GFI EventsManager tests the connection automatically after you click Next.
7. Select the columns you want to export and click Next.
To export all columns, select Export all columns.
8. Configure the following filtering options and click Next:
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.
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.
9. Select when the job is executed and click Finish:
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.