Contact Us

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

VMware

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.

Privacy Settings
We use cookies to enhance your experience while using our website. If you are using our Services via a browser you can restrict, block or remove cookies through your web browser settings. We also use content and scripts from third parties that may use tracking technologies. You can selectively provide your consent below to allow such third party embeds. For complete information about the cookies we use, data we collect and how we process them, please check our Privacy Policy
Youtube
Consent to display content from Youtube
Vimeo
Consent to display content from Vimeo
Google Maps
Consent to display content from Google
Spotify
Consent to display content from Spotify
Sound Cloud
Consent to display content from Sound