Skip to content
DataMiner DoJo

More results...

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
Search in posts
Search in pages
Search in posts
Search in pages
Log in
Menu
  • Updates & Insights
  • Questions
  • Learning
    • E-learning Courses
    • Empower Replay: Limited Edition
    • Tutorials
    • Open Classroom Training
    • Certification
      • DataMiner Fundamentals
      • DataMiner Configurator
      • DataMiner Automation
      • Scripts & Connectors Developer: HTTP Basics
      • Scripts & Connectors Developer: SNMP Basics
      • Visual Overview – Level 1
      • Verify a certificate
    • Video Library
    • Books We Like
    • >> Go to DataMiner Docs
  • Expert Center
    • Solutions & Use Cases
      • Solutions
      • Use Case Library
    • Markets & Industries
      • Media production
      • Government & defense
      • Content distribution
      • Service providers
      • Partners
      • OSS/BSS
    • Agile
      • Agile Webspace
      • Everything Agile
        • The Agile Manifesto
        • Best Practices
        • Retro Recipes
      • Methodologies
        • The Scrum Framework
        • Kanban
        • Extreme Programming
      • Roles
        • The Product Owner
        • The Agile Coach
        • The Quality & UX Coach (QX)
    • DataMiner DevOps Professional Program
      • About the DevOps Program
      • DataMiner DevOps Support
  • Downloads
  • More
    • DataMiner Releases & Updates
    • Feature Suggestions
    • Climb the leaderboard!
    • Swag Shop
    • Contact
    • Global Feedback Survey
  • PARTNERS
    • All Partners
    • Technology Partners
    • Strategic Partner Program
    • Deal Registration
  • >> Go to dataminer.services

Automated, periodical csv file export of trend data to a shared drive.

Solved594 views8th August 2023
4
Pedro de Lima [DevOps Advocate]612 21st July 2023 0 Comments

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.

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 8th August 2023

1 Answer

  • Active
  • Voted
  • Newest
  • Oldest
1
Miguel Obregon [SLC] [DevOps Catalyst]19.12K Posted 23rd July 2023 0 Comments

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.

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 8th August 2023
Please login to be able to comment or post an answer.

My DevOps rank

DevOps Members get more insights on their profile page.

My user earnings

0 Dojo credits

Spend your credits in our swag shop.

0 Reputation points

Boost your reputation, climb the leaderboard.

Promo banner DataMiner DevOps Professiona Program
DataMiner Integration Studio (DIS)
Empower Katas
Privacy Policy • Terms & Conditions • Contact

© 2025 Skyline Communications. All rights reserved.

DOJO Q&A widget

Can't find what you need?

? Explore the Q&A DataMiner Docs