How to add your own reports to VMTurbo 4.7 – Part1

Blog Post created by iddo.avneri on Sep 25, 2014

Generating a report isn't the same as having software figure out the actions you need to take and take them for you. But often it seems like we can’t do our jobs without it. (Keeps the boss happy? Helps us make our point?)


VMTurbo collects performance and utilization metrics from your environment, and gives you the flexibility to present it through Custom Dashboards (VMTurbo Ops Mgr v4.7 What's New: Reporting ).


The New Reports Tab


p1-2.jpgYou can always click “Help” -> “Quick Help” to get the online help on top of the screen you are using.


The new reports tab is build out of 3 sections. In a high level these are the panels and main functions:


1. Reports panel on the left:

This panel lists the reports that are currently available, including standard reports and saved custom reports (reports generated from the Dashboards or Inventory views). When you select an item in this list, the Generate/View Report and Schedule Reports panels show details for that report type.

You can search for the available reports. For example, if you write “CPU” in the upper left text box, you will get the list of all reports that have the world CPU in their title.

The clock icon indicates a report that has been scheduled - Operations Manager will generate the report at regular intervals. To subscribe to a report, provide an email address along with the schedule parameters.
To change the list sort order, click the Pencil icon. You can also filter the list content by report names.
To see all details for all the scheduled and subscribed reports, click Show All Schedules. The Schedule Reports panel displays the details.


2. Generate or Fetch Historical Reports on the upper right panel:

Use this panel to get copies of the report that you have selected in the Reports panel.

Operations Manager generates scheduled reports on a regular basis, and saves them on the Operations Manager server.  You can set a date range and then click Fetch to see a list of the reports that have been generated in that period of time. Then you can choose specific reports to download or view in PDF or Excel format.

For an up-to-the-minute report, click Generate Now. Operations Manager generates a copy of the report with the latest data, and displays it.


3. Scheduled Reports Panel on the lower right:

Use this panel to schedule report generation and set up subscriptions. After you schedule a report, it appears in the Reports list with a clock icon.

To schedule a report, select it in the Reports panel and click Add, then specify the schedule parameters. To set up a subscription, provide one or more email addresses with the schedule parameters. You can create more than one subscription entry for a report.
To cancel a scheduled report, select it in the list and click Remove. When you remove all the schedule entries, Operations Manager no longer generates that report.


However, it doesn't stop there. Starting 4.7 any inventory or dashboard view can be saved as a report, and the functions described above can be run against these new created customized views.


Adding Reports from an Inventory Tab


The Inventory tab can be accesses directly or it is opened every time you click the details button 



p1-2.jpgYou can always click “Search” to open the details view for any entity in the system directly.


Once the tab is open you can customize it. For example:

1. Change the time frame on a trend widget:


2. Choose the metrics to show on a consumption widget:




Once you have the screen you are happy with. Click on the generate report button on the upper left section and chose “Save as Report”:


Name your new report:


Congratulations! You successfully added a new reports to the report tab:


Like any other report, it can be generated on demand, scheduled to run automatically or subscribed to an email address.

Adding Reports from a Custom Dashboards

There is a separate interesting thread about creating custom dashboards:  as well as several discussions around additional customization you might want to take here in the community:* 


In 4.7 we added additional flexibility to the custom dashboards you can create. (For example, you can create a pie chart of the Operating Systems distribution).

Once again, dashboards can be saved as reports that later on can be generated on demand, scheduled to run automatically or subscribed to an email address. This will be done in the exact way as done in the inventory tab:



Read the next blog "How to add your own reports to VMTurbo 4.7 – Part2" in order to find out how you can further more write queries against the VMTurbo DB and have those saved as reports within the product.