True Visibility with Custom Reports in vRealize Operations

by bluemedora_editor on June 17, 2015

Last month, VMware’s Cloud Management blog post showed you how to integrate discrete management packs with custom dashboards. Another key tool in the vRealize Operations utility belt is the reports system. While the core system and many management packs ship with ready-made reports, users can also create custom reports.

One way to exploit the vRealize Operations reports system is to create custom reports that meet the needs of stakeholders across your organization. Once designed, these reports can be automatically generated and delivered via email. In this use case, we will make a report for a database analyst (DBA) who wants a virtual and storage layer view of both database memory and disk. In this hypothetical environment we have installed two Blue Medora management packs:

 

Creating a Custom View

Reports in vRealize Operations are composed of views. You can either choose out-of-box views (views provided with the core application or third party management packs) or you can create custom views. We will use a mix of out-of-box and custom views for our DBA report.
To create a new view, go to the Environment screen, drill down to an object (in this case an Oracle database), and click the Details tab. Here you’ll click the add (+) button to create a new view. Stepping through the View wizard, we:

    • Give the view a name, Database Memory and Disk List
    • Select a presentation type, List
    • Select the subject, OEM – Database Instance
    • Choose the metrics to expose:
      • Memory Usage | Total Memory Usage (MB)
      • Database Size | Used Space (GB)
      • Database Size | Allocated Space (GB)

 

We can leave Visibility with its default settings and save the view. Once saved, this view will become available for inclusion in dashboards and reports.

Creating Custom Reports

Now we’ll move over to the Reports tab. Reports in vRealize Operations come from the viewpoint of a particular object, e.g., an ESXi Host, VM or database instance. When creating a report, just as with a view, you need to decide what type of object is the subject of that report. We want to create a report that shows details from:

  • An Oracle database
  • A NetApp volume
  • A VMware virtual machine

In this case, we are starting from the vantage point of a VM. We navigate to a VM hosting Oracle database and click add (+) to create a new report. We will add our newly created view and bring in some out-of-the-box views for the VM and NetApp volume.

Once the report is designed, we can schedule automatic generation and delivery by clicking the gear button.

Our finished report breaks down the disk and memory from the database, through the VM and into the storage layer. Using custom reports, we can leverage vRealize Operations to ensure our DBA team can get monthly, weekly or even daily reports on the health of their database. You can do the same by creating custom reports to further enable your organization to gain true visibility.

Get started

Try BindPlane for free. No credit card required.

Sign up
True Visibility
BindPlane for VMware vRealize Operations

True Visibility allows cloud management teams to use VMware vRealize’s powerful machine learning and capacity planning engine across their entire hybrid cloud environment.

Azure Monitor...everything
BindPlane for Microsoft Azure Monitor

Make Azure Monitor your first-pane-of-glass across your entire multi-cloud, multi-database or hybrid platform environment.

Thank you for contacting us. Your information was received. We'll be in touch shortly.