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

What is the best approach to have a single graphic for multiple servers sent by email?

Solved1.48K views13th July 2023DMS Reporter Reports
3
Bruno Sousa [DevOps Member]669 7th July 2021 0 Comments

Hello

My client is requesting a report by email which shows a graphic for multiple servers for a single KPI (for example: CPU).

In the present, what is the best approach to achieve that in your opinion?

Thank you.

Best regards

Bruno Sousa

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

3 Answers

  • Active
  • Voted
  • Newest
  • Oldest
0
Pieter Van Compernolle [SLC] [DevOps Enabler]3.26K Posted 8th July 2021 1 Comment

Bruno,

Here is an example of such a join in the query.
This is how you go from your initial query to this one:

  • Add a join node
  • specify the data source you want to join (optionally you can filter, … this branch till you have a table ready-to-join). In this case I’m joining the full element table. I choose for a ‘left’ join as I only want rows from my initial (left) table.
  • In the join node, you also need to configure the ‘linking’ between the two tables, so basically the columns in the left and right table that hold the same information. In this case this is the ‘Element ID’ column which we have in both tables.
  • At the end of the query, I have added a ‘Select’ node to limit the number of columns in my result and I shifted the Name columns in front of the ‘Total Processor Load’ column.

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 13th July 2023
Bruno Sousa [DevOps Member] commented 8th July 2021

Really nice!

Thank you for the help Pieter!

Best regards
Bruno Sousa

0
Pieter Van Compernolle [SLC] [DevOps Enabler]3.26K Posted 7th July 2021 2 Comments

Miguel showed you how you could achieve a time series chart for your parameters. In case you want a snapshot of the current value instead, you can take the GQI approach with a query like:

and visualize the result in one of our chart visualizations:

PS: with a join of Element data in your query you can have element names instead of IDs.

Next to displaying the current value, you can also calculate statistics based on the trend info, like the average value over time for example (currently still restricted on one element, but will be extended soon). And we have some more extensions coming up (10.1.8 – 10.1.9) like time patterns where you will be able to filter on business days/hours for example.

If you want to have it sent by email then, you can follow the same last step Miguel mentioned.

Pieter Van Compernolle [SLC] [DevOps Enabler] Posted new comment 8th July 2021
Bruno Sousa [DevOps Member] commented 7th July 2021

Thank you both for the suggestions!

1. I don’t see a way to filter by element on the line chart.. maybe I’m doing something wrong? I’m using Dataminer’s last version 10.1.7

2. Pieter, any example on how to perform the join that you mention, to get the Element name instead of the id?

Thank you.

Best regards
Bruno Sousa

Pieter Van Compernolle [SLC] [DevOps Enabler] commented 8th July 2021

see separate answer (as I wanted to insert images, which I can’t do in a comment)

0
Miguel Obregon [SLC] [DevOps Catalyst]19.12K Posted 7th July 2021 1 Comment

Hi Bruno,

I believe that the best way to generate this report is using the Dashboard app. Please find below the steps that should cover your use case:

  • Create a dashboard that contains the component Line Chart. See DataMiner Help (Line & area chart) for additional information about charts
  • In the new dashboard, as data source, select Parameters. In the filter options select:
    • From: Protocol
    • Protocol: The name of the protocol
      In the example below, I added the parameter Total Processor Load from the connector Microsoft Platform:

    • Add this selection to the line chart component
  • For filtering select Elements. In this case add to the line chart component the elements that will be included in your report
  • Select the component and go to Settings:
    • If required, change the timespan according to your requirements
    • In the option ‘Group by’, select the option ‘All together’. This will display all the lines in the same chart:

  • Finally, generate the report based on the dashboard. You can find in DataMiner Help – Generating a report based on a dashboard additional information about how to generate this report
Bruno Sousa [DevOps Member] Posted new comment 8th July 2021
Bruno Sousa [DevOps Member] commented 8th July 2021

It worked!

Thank you for the help, Miguel!

Best regards
Bruno Sousa

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