Tools->Options->General options->Trend Export->Configure->New
You can configure trends to be automatically exported to specific SQL databases directly from the Trend Exporter window.
In the Export Task Wizard window you can add a new trend exporting task, delete or change its properties or manage any previously setup database connections.
When adding or modifying a trend exporting task, the following needs to be indicated or changed:
- Task Name
- Specifies the name for the trend exporting task.
- Export Trend Data by Counter or From Nodes
- Specifies whether you should first choose trend counters or nodes for the exporting task.
- Counter Type
- Specifies the counters whose trends are to be exported to the indicated SQL database.
- Nodes
- Specifies all chosen nodes whose trends are to be exported to the indicated SQL database.
- Trend Type
- Specifies day, day by hours, week, weekly distributions by hours, month, monthly distribution by hours or monthly distribution by weekday.
- Database
- Specifies connection name, database server type, server name, database name, authentication type, login name and password.
To setup automatic trend export capability:
- Select the Options item from the Tools menu. The Options window displays program options.
- In General Options select Advanced check box and select Trend Export page.
- Select the Enable Automatic Trend Export check box.
- Click Configure. The Trend Exporter window opens.
- To add new trend exporting task, from the menu select the New option. Follow directions in the opened Export Task Wizard window.
Note: To change the properties of a previously created trend exporting task, select the task from the list and from the menu select the Properties option. Follow directions in the opened Export Task Wizard window.
The database server types supported for automatic trend exporting are the following: MS SQL Server, MS Access, Oracle, MySQL, Interbase and ODBC.
Please note that Trend Exporter is only available in the NetCrunch Administration Console running locally on the machine where NetCrunch Server is installed.
