...
- Open the Tasks console (see Tasks), and click the New Task button.
- In the page that opens, select the Collection to Database option, and then click Continue.
The Collection to DatabaseTask page opens. - In Name, type the name of the new task.
- In Description, type a description of the new task; optional.
- In Collected Log, click Select log, and in the Select Log to Collect window that opens, select a log that will be exported to a database.
- In Data Filter Query, type a query to filter out events that don't satisfy the above query.
- In Connection Details, select the Database account to use, or click New to define a new Database account (see Creating an Account).
- Enter the table name that data will be exported into. Under 'database advanced settings' you can see the CREATE TABLE and INSERT statements that will be used.
- Open To schedule the task for automatic running, open the Schedule tab.In Set Frequency, select the frequency of task execution: Never, Daily, Weekly, or Monthly, and then complete the options that appear for your selected frequency, and set the parameters as described in Scheduling a Task.
- Click Save.
The Collection to Database task is saved.