vRealize Operations Manager (vROps) 8.0 – How to create a report to show virtual machine’s with mounted ISO

Posted by

One of the custom views I like to create is the ability to see which VMs in my clusters have a mounted ISO file.  There are many justified reasons to mount an ISO file via the CD-ROM on a virtual machine.  However, this prevents the VM from being able to vMotion.  This can impact things like DRS or the ability to vMotion a VM while trying to put a host into maintenance mode for an upgrade.  Below are the steps I took to create a custom view and report to show all the VM’s with mounted ISO files.

Pre-Req:
If you haven’t already go to Home > Troubleshoot > Compliance and enable vSphere Security Configuration Guide
—If you do not do this then you won’t get the security metrics required to create the custom view.

Step 1.  Create the view

Machine generated alternative text:
vm vReaIize Operations Manager 
Home 
Dashboards 
Environment 
Administration 
BACK 
Dashboards 
Getting Started 
SDDC Health Historic Trend 
SDDC Management Health 
SDDC vROps Sizing Dashbord 
Reports 
Views 
Desc

New view

Machine generated alternative text:
1 Name and Description 
Description: 
Presentation 
Subjects 
x 
CANCEL

Give it a name like -> VM’s with Mounted ISO

Machine generated alternative text:
VMIs with Mounted ISO - 
Name and Description 
2 Presentation 
Summary 
Trend 
Distribution 
Tex-t 
Image 
Subjects 
CANCEL

List -> we just need to see a list of the VM’s, nothing fancy here.

Machine generated alternative text:
VMIs with Mounted ISO - 
Name and Description 
2 Presentation 
3 Subjects 
Virtual Machine 
Add subject 
Group by: 
None 
4 Data 
Visibility' 
Sample data 
Column 2 
Property Value 1 
Property Value 2 
Property Value 3 
Property Value 4 
Property Value 5 
Column 3 
Select preview source„ 
Column 4 
Summary 
Configuration 
x 
V 
Preview source: 
Column I 
Object 
Object 
Object 
Object 
Object 
Name 1 
Name 
Name 3 
Name 
Name 5 
Time Settings 
Breakdown by 
Transformation 
Drag the data to include in the view. 
Select a metric or property to 
configure 
Click to select what metrics / properties 
appear in the view. 
CANCEL

Select vCenter > Virtual Machine for subject

Machine generated alternative text:
VMIs with Mounted ISO - 
Name and Description 
2 Presentation 
3 Subjects 
4 Data 
Sample data 
Column 2 
Property Value 1 
Property Value 2 
Property Value 3 
Property Value 4 
Property Value 5 
Column 3 
Select preview source„ 
Column 4 
Summary 
Configuration 
x 
V 
Preview source: 
Column I 
Machine 
Object 
Object 
Object 
Object 
Object 
Name 1 
Name 
Name 3 
Name 
Name 5 
Virtual 
Select data 
Metrics 
Badge 
Capacity Analytics Generated 
Configuration 
Cost 
cpu 
CPL' Utilization lor Resources 
Datastore 
Disk Space 
Disk Space Usage on Datastore 
Guest File System 
Memory 
Memory Usage on Host 
Network 
Physical Disk 
Storage 
Visibility' 
Time Settings 
Breakdown by 
Transformation 
Drag the data to include in the view. 
Select a metric or property to 
configure 
CANCEL

Change metric to properties

Machine generated alternative text:
VMIs with Mounted 
ISO - 
Metric name: 
Sample data 
Column 2 
Property Value 1 
Property Value 2 
Property Value 3 
Property Value 4 
Property Value 5 
Column 3 
Select preview source„ 
Configuration 
x 
Name and Description 
2 Presentation 
3 Subjects 
4 Data 
V 
Preview source: 
Column I 
Column 4 
Summary 
Machine 
Object 
Object 
Object 
Object 
Object 
Name 1 
Name 
Name 3 
Name 
Name 5 
Virtual 
Select data 
Properties 
Summary 
operating 
Guest Operating System 
Guest as Full Name 
Guest OS IP Address 
Hostname 
Tools Running Status 
Tools Version 
Tools Version Status 
Visibility' 
Time Settings 
Breakdown by 
Transformation 
SummarylGuest Operating Systeml_ 
Current 
Drag the data to include in the view. 
General: 
Metric label: 
Sort order: 
SummarylGuest 
SummarylGuest C 
Not Available 
Transformation: 
Current 
No Timestamp 
Show advanced settings 
CANCEL

Drag and drop Guest OS Full Name into the data section

Machine generated alternative text:
Time Settings 
Virtual Machine filter 
Breakdown by 
Summary 
Virtual Machine 
Metric 'Ælue 
Add Reset 
Select the Object Type that matches all 01 the 
following criteria: 
Metrics 
Add another criteria set 
Pick a metric

Go to Filter – Change Metric to Properties

Machine generated alternative text:
Time Settings 
Virtual Machine filter 
Breakdown by 
Summary 
Virtual Machine 
disconnect 
Add Reset 
CANCEL 
Select the Object Type that matches all 01 the 
following criteria: 
Properties 
Add another criteria set 
Configuration 
Security 
Disconnect CD-ROM 
Disconnect floppy drive 
Disconnect parallel port 
Disconnect serial port 
Disconnect usa controller

Configuration > Security > Disconnect CD-ROM
You can also filter by disconnect and select CD-ROM

Machine generated alternative text:
Time Settings 
Virtual Machine filter 
Breakdown by 
Summary 
Virtual Machine 
Add Reset 
CANCEL 
Select the Object Type that matches all 01 the 
following criteria: 
Properties 
Add another criteria set 
ConfigurationlSecuritylDisconn is

Select “is”
Select “false”
Then “Save”

Step 2. Create the report

Machine generated alternative text:
vm vReaIize Operations Manager 
Home 
Dashboards 
Generated Reports 
ACTIONS 
BACK 
Dashboards 
Getting Started 
Heaw Hitter VMS 
Datastore Utilization 
VM Utilization 
Host Utilization 
Cluster Utilization 
Operations Overview 
Utilization Overview 
Host Usage Overview 
Datastore Usage Overview 
Capacity Allocation Overview 
vSAN Capacity Overview 
Migrate to vSAN 
vSAN Operations Overview 
vSAN Stretched Clusters 
SDDC Health Historic Trend 
SDDC Management Health 
SDDC vROps Sizing Dashbord 
Reports 
Reports 
Report Templates 
Bbme 'l' 
CVOAI Analyze Events 
Generated reports (O) 
CVOAI Optimize Capacity 
Generated reports (1) 
CVOAI Optimize Configuration 
Generated reports (O) 
CVOAI Optimize Performance 
Generated reports (O) 
CVOAI Summary Report 
Generated reports (O) 
Capacity Report - Datastores 
Generated reports (O) 
Capacity Report - Distributed Port Group 
Generated reports (O) 
Capacity Report - Distributed Switch 
Generated reports (O)

Dashboards > Reports > New Template

Machine generated alternative text:
VMIs with Mounted ISOS - New Template 
1 Name and Description 
VM's with Mounted ISOS 
Description: 
x 
V 
Views and Dashboards in the report (sample data) 
Click to select the views or dashboards to 
include in the report template. 
CANCEL 
This report is to show all the virtual machines with 
a mounted ISO -tile 
2 Views and Dashboards 
Layout Options

Give the Report a name and description that will make it easy to filter by in the future

Machine generated alternative text:
VMIs with Mounted ISOS - New Template 
1 Name and Description 
2 Views and Dashboards 
Data type 
VM's with Mounted ISO 
Layout Options 
V 
Search views 
Views and Dashboards in the report (sample data) 
CANCEL

Use the filter to locate the view we created earlier

Machine generated alternative text:
VMIs with Mounted ISOS - New Template 
x 
1 Name and Description 
2 Views and Dashboards 
Data type 
VM's with Mounted ISO 
3 Formats 
4 Layout Options 
V 
Search views 
Views and Dashboards in the report (sample data) 
CANCEL 
x 
VMls with Mounted ISO 
Colorization 
SummarylGuest Operati__ 
Property Value 1 
Property Value 2 
Property Value 3 
Property Value 4 
Property Value 5 
Virtual 
Virtual 
Virtual 
Virtual 
Virtual 
Click 
Machine 1 
Machine 
Machine 3 
Machine 4 
Machine 5 
to expand and select report 
components.

Double click the view to move it over
You can play around with format and layout or you can click save to create the custom report
Finally, you can now run the report against the object you desire.

Summary:
I find this report to be very useful and time saving when doing things like upgrade prep.  I understand if you aren’t aware of where to look for all the little details it can be tedious to create this view and report.  As always I hope this article helps anyone out there who has been having struggles generating a report like this.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s