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

Reporting Customization – TOP lists sorting

Solved1.11K views11th July 2023
3
Euler Peron [DevOps Member]107 27th October 2020 0 Comments

Hello Everybody. hope you all are doing fine.

We´re doing some custom reporting inside Our cluster and have been able to set a lot of parameters and selecting only what we need on the reports.

One of the reports is about some network elements (mostly Cisco and Juniper switches) where we query only the desired interfaces utilization and bring the report of them alltoghether in a table with Maximum, minimum and Average.

The second step in that report will be: try to get a way to sort the elements and interfaces from top-botton based on the parameters, and then do a 95 percentile to filter out only the switches that surpass that utilization on the time period that we report.

This second step is a little tricky because it seems that we cannot use these kind of logics inside the reporting module.

So there go my questions: 😉 LOL

do you guys do such reporting and KPI based on queries for parameters? or stay with the regular options on the reports module?
If you do so, how do you filter out or organize the data on the results of the reports? Do you use any kind of scripting or any other tool?

I will be very gratefull if someone can contribute with your experiences.

Best regards.

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

1 Answer

  • Active
  • Voted
  • Newest
  • Oldest
2
Ben Vandenberghe [SLC] [DevOps Enabler]9.09K Posted 29th October 2020 1 Comment

This is not a definitive answer to your inquiry, but I did want to take the opportunity to highlight a new upcoming capability in DataMiner that we are working on, and that’s the GQI (Generic Query Interface).

This is going to be made available both as a standard API as well as a ‘data source’ that you can leverage in the new Dashboards module in a very intuitive manner (those new Dashboards will also have reporting capabilities, i.e. dispatching dashboard snapshots as PDF files).

We’ll work on providing more details on the GQI, but in short: it is a very flexible graph-style of API, that you can leverage to query DataMiner for specific datasets.  To give you a simple use case example already covered by the current version:

A. you can ask for example for all elements of a specific type (e.g. give me all my Linux Servers – and it would return a list of all Servers).

B. you can then say that for all those, you would like to have the CPU load and the Memory Utilization and the OS Version (and it will return a table, with one row for each server, and a column for the value of each of the metrics you asked for).

C. you could then say that you would like to filter the list for a specific version of the OS (and it will return a table, where it removed all the servers that fall outside your filter).

D. you could then say that you would like to keep only the TOP-5 based on the CPU Load metric (and again it would update that table for you – note: each time you rerun the query, it would update the table for you find the servers that match your criteria).

E. you could then say for example that you want to have the average of Memory Utilization of all those servers that remain (and it would return one figure, being the average Memory Utilization of the top-5 servers based on CPU load, only considering the ones with the OS Version that you specified).

Now, this is a simple use case.  Because there are a lot of other options already supported by the GQI (such as performing aggregations such as SUM, Min, Max, Average, Count, Distinct Counts, Median, Percentiles, etc.).   A really powerful capability is that you can perform multiple of those queries and combine them (i.e. each query would give you a table of data, and if you have two of those you can then merge them together).   And of course the powerful proposition is that all data in DataMiner can be leveraged (e.g. if you use IDP in DataMiner, you could easily go and start filtering your servers in the use case above based on their location, their room, the rack they reside in, etc. Or leverage information on active services running, bookings, tickets, alarm states, etc.).

One thing that you mention that is not yet covered by the GQI is that you refer to a percentile across the time trace of a metric for a specified period (i.e. GQI supports a percentile across a specific metric in a column, but not across the time trace of a single metric).  But that’s a great use case, so we definitely will take that on board.

Just wanted to share this already with you, and we’ll get back asap on the options that you would have today without the GQI to get your use case covered.

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 11th July 2023
Euler Peron [DevOps Member] commented 3rd November 2020

Very good Ben, and thanks for the answer.

I´ll dig down and learn more on the GQI

Thank you very much.

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