Adding a Collection to Database Task

To add a Collection to Database task (this task will export data from XpoLog log into a specified database):

1. Open the Tasks console (see Tasks), and click the New Task button.
2. In the page that opens, select the Collection to Database option, and then click Continue.
   The Collection to DatabaseTask page opens.
3. In Name, type the name of the new task.
4. In Description, type a description of the new task; optional.
5. 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.
6. In Data Filter Query, type a query to filter out events that don't satisfy the above query.
7. In Connection Details, select the Database account to use, or click New to define a new Database account (see Creating an Account).
8. 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.
9. Open the Schedule tab.
10. 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.
11. Click Save.
    The Collection to Database task is saved.