I would like to automate periodical csv file exports of trend data for a particular parameter from a particular element directly to a shared drive location. What's the best way of doing this.
Hi Pedro,
A possible option is to use the DataAggregator module (DxM).
The DataAggregator DxM allows you to execute a GQI query at a specific time and store the result of this query in a CSV file.
Information about the installation and setup can be found in DataMiner Docs. You can install this module in any DMA of a cluster.
Using Dashboards, you can create a GQI query with the following details:
- Data Source: Get trend data
- Trend Type: Average or Real time
- Protocol: The protocol of the element
- Version: The version of the protocol assigned to the element
- Parameter: The parameter that you would like to export the trend data
If you display this information in a table component, you will find 4 columns:
- Start time: Start time of the trend data record stored in DB
- End time: End time of the trend data record stored in DB
- Instance: The index of the column parameter (in case you selected a column parameter)
- Element ID: DataMinerID/ElementID of the element
This GQI query will return values from all the elements available in the cluster that match the options of your query.
In case you would like to show only data from one specific element, you can add an extra filter
Once you are happy with the result of the GQI query, next you can follow the steps available in DataMiner Docs to export your GQI query to the DataAggregator.
When configuring the DataAggregator you can set how often a job will execute the GQI query that you exported previously. For example, if you configure a job to be executed every day at 01:00, a CSV file will be generated every day in the folder defined in your settings.
Hope it helps.