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
  • Blog
  • Questions
  • Learning
    • E-learning Courses
    • 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
    • Tutorials
    • 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
    • DataMiner Insights
      • Security
      • Integration Studio
      • System Architecture
      • DataMiner Releases & Updates
      • DataMiner Apps
    • 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
  • Downloads
  • More
    • Feature Suggestions
    • Climb the leaderboard!
    • Swag Shop
    • Contact
      • General Inquiries
      • DataMiner DevOps Support
      • Commercial Requests
    • Global Feedback Survey
  • PARTNERS
    • All Partners
    • Technology Partners
    • Strategic Partner Program
    • Deal Registration
  • >> Go to dataminer.services

Force update to all 5 min avg trend data one a day?

Solved1.13K views7th July 2023MySQL
4
Jeff Douglass860 1st February 2023 0 Comments

For MySQL based systems, is there a way to force DM to update/refresh all 5 min avg trend data for all avg trending enabled data points, or for just elements of a particular protocol type, regardless of if a point's value has changed or not? Similar to what happens when DM is restarted. Why do I ask? I would like to force DM once a day, say at midnight, to not only save avg trending data for values that have changed but also for values that have NOT changed. This way, there would always be at least one entry every day for every trended parameter. This would remove the need for special database cleaning logic to ensure data points whose values have not changed are still plotted without blank spots in the graphs. Thanks

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 7th July 2023

1 Answer

  • Active
  • Voted
  • Newest
  • Oldest
1
Floris Cockaerts [SLC] [DevOps Advocate]2.43K Posted 1st February 2023 1 Comment

Hi Jeff,

The closest thing to what you are asking is probably the following notify, which only works for history set parameters: NT_CLOSE_HISTORY_TREND_WINDOW (374) | DataMiner Docs

To my knowledge, even if trend windows are closed, there won't be an additional entry in the database if the value is the same as previous windows. And there likely isn't any integrated functionality to do this.

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 7th July 2023
Jeff Douglass commented 1st February 2023

Thanks Floris. Hoping maybe someone else has an idea. It would be interesting to know how DM handles this in Cassandra based systems since Cassandra will simply delete records based on the record’s TTL without any concern whether the value has not changed in an extended period of time. Thanks again.

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

Recent questions

Web Applications exception in Cube due to invalid certificate 0 Answers | 0 Votes
Redundancy Groups and Alarming – Duplicate Alarms 0 Answers | 0 Votes
Correlation Engine: “Test rule” doesn’t result in a hit, despite functional rule 1 Answer | 3 Votes

Question Tags

adl2099 (115) alarm (62) Alarm Console (82) alarms (100) alarm template (83) Automation (223) automation scipt (111) Automation script (167) backup (71) Cassandra (180) Connector (109) Correlation (69) Correlation rule (52) Cube (151) Dashboard (194) Dashboards (188) database (83) DataMiner Cube (57) DIS (81) DMS (71) DOM (140) driver (65) DVE (56) Elastic (83) Elasticsearch (115) elements (80) Failover (104) GQI (159) HTTP (76) IDP (74) LCA (152) low code app (166) low code apps (93) lowcodeapps (75) MySQL (53) protocol (203) QAction (83) security (88) SNMP (86) SRM (337) table (54) trending (87) upgrade (62) Visio (539) Visual Overview (345)
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

[ Placeholder content for popup link ] WordPress Download Manager - Best Download Management Plugin