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:
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:
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.
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:
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.