Creating Custom Reports and Dashboards Using MySQL Queries

August 20th, 2015 by

If I were to ask the owner of a traditional alerting or monitoring tool why they need reports of their virtual environment’s state, it would probably seem like a silly question. Of course you need reports to help you determine what action(s) to take after crossing a threshold, right? Well sure, if the optimal decisions weren’t already given to you automatically, then I suppose you would. Now, what if you had software determining, in real-time, before any performance degradation occurs, what the appropriate actions to take are to prevent a bottleneck. Would you still use that report in the same way?

Reports are for Updating, Not Troubleshooting

At VMTurbo, we understand the business need for reporting, the ability to easily drill down to specific data points, for consumption by different teams at regular intervals. However, with VMTurbo, you’ll never find yourself digging through a report to identify and figure out how to remediate a problem. That’s the key difference. Maybe you’ll want to create a report showing how healthy your environment is, or outlining a list of executable rightsizing recommendations to be taken during non-production hours. There are many reporting capabilities that VMTurbo offers, and we’ve recently introduced a new method through the use of MySQL queries.

VMTurbo DashboardsVMTurbo Query Results

In addition to generating a PDF or .CSV report by leveraging our publicly available database schema, we’ve added the ability to create custom dashboards in the same way. When creating a custom dashboard, you’ll now see the option to use a Query Result in the dropdown:

VMTUrbo SQL Report

So if we wanted to see a dashboard of our Daily VM Storage By Drive, we’d select the report we wanted, and VMTurbo converts the SQL report into a chart that can be resized as you wish:

VMTurbo SQL Report Results

This allows us to build visual dashboards depicting historical data that spans further than 60 days. Additionally, we can customize exactly which entities and data points are pulled into the dashboard, and specify how the column structure should be organized. Furthermore, since we have the ability to customize a dashboard with up to 16 individual panes, you can update your colleagues on the state of your environment.

Report with the Right Mindset

Remember that with VMTurbo, the software does the work for you—it prevents degradation in your environment. No need for alerts or troubleshooting. It’s important to have the right mindset when you’re creating reports—they’re a means of helping you communicate across roles and departments. Use them for anything else and you’re back in the break-fix mindset.

Leave a Reply

Your email address will not be published. Required fields are marked *