...
A Collection to Database task
...
exports data from an XpoLog log into a specified database
...
.
To add a Collection to Database task:
- Open the Tasks console (see Tasks), and click the New Task button
OR
In the XpoLog Manager homepage, under More Actions, click Add Task. - In the page that opens, select the Collection to Database option, and then click Continue.
The Collection to DatabaseTask Database Task 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 export to a database.
- In Data Filter Query, type a query to filter out events that don't do not 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 intoname into which data is to be exported. Under 'database advanced settings', you can see the CREATE TABLE and INSERT statements that will be used.
- Open To automate task execution, 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 configure the scheduler as described in Scheduling a Task.
- Click Save.
The Collection to Database task is saved.