Posted by Have you ever needed a quick way to discover any and all virtual machines in your environment that have a mounted ISO? An example of this would be you are going to be performing an ESXi or VXRail upgrade and need the ability to migrate VMs from one host to another as part of maintenance mode. Below I will walk you through creating a metric to identify VM’s with a mounted ISO and how to turn that metric into a report that can be run.
How to Create the Metric
Go to Dashboards > Views > New View
Provide the View a name and description to help find in the future.
Select list under Presentation
Under subject select vCenter Adapter > Virtual Machine
![Machine generated alternative text:
v 4 _ Data
Select data
Metrics
Virtual Machine
g] Capacity Analytics Generated
g] Configuration
g] Cost
> B] cpu
g] CPU Utilization for Resources
g] Datastore
g] Disk Space
g] Disk Space usage on Datastore
g] Guest
Guest File System
g] Memory
Memory usage on Host
Network
g] Physical Disk
g] Storage](https://i0.wp.com/digitalthoughtdisruption.com/wp-content/uploads/2020/05/6-1.png?resize=359%2C520&ssl=1)
Change Metrics to Properties
![Machine generated alternative text:
v 4 _ Data
Select data
Virtual Machine
Properties v
> g] Configuration
> B] CPU
> Memory
> g] Network
> g] Runtime
v Summary
> Configuration
> Custom Tag
Datastore(s)
v Guest System
Guest OS Full Name
Object Name 2
Object Name 3
Object Name 4
Object Name 5
Data
Data
Property Value 2
Property Value 3
Property Value 4
Property Value 5
Value 2
Value 3
Value 4
Value S
Value 2
Value 3
Value 4
Value S
Summary
Configuration
I - IS of IS items
Time Settings
Breakdown by
Transformation
Filter
Drag the data to include in the view.](https://i0.wp.com/digitalthoughtdisruption.com/wp-content/uploads/2020/05/7-2.png?fit=810%2C266&ssl=1)
Navigate to Summary > Guest Operating System > Guest OS Full Name
![Machine generated alternative text:
Select data
Virtual Machine
Properties v
> g] Configuration
> B] CPU
> Memory
> g] Network
> g] Runtime
v Summary
> Configuration
> g] Custom Tag
Datastore(s)
v Guest System
Guest OS Full Name
Guest OS IP Address
Hostname
Tools Running Status
Tools Version
Tools Version Status
> 5. Visibility
Object Name 4
Object Name 5
Data
Data
Property Value 4
Property Value 5
Value 4
Value S
Time Settings
Filter
Value 4
Value S
Summary
Breakdown by
Transformation
SummarylGuest Operating SystemlG„_ Current
Drag the data to include in the view.
Configuration
General:
Metric name:
Metric
units:
Sort order:
I - IS of IS items
SummarylGuest
Summary'Guest O
None
Transformation:
Current
No Timestamp
Show advanced settings
CANCEL
SAVE](https://i2.wp.com/digitalthoughtdisruption.com/wp-content/uploads/2020/05/8-2.png?fit=810%2C390&ssl=1)
Then drag and drop that property into the view plane
This section is good and next we click on Time Settings
I leave it at 7 days
I leave Breakdown by blank
We need to change Metrics to Properties
Navigate to Configuration > Security > Disconnect CD-ROM
Under Select put : is
Under Property Value type: false
Then click save
How to Turn Metric into Report
On the left plane you can click Reports
Select New Template
Give the Report a name and description
Filter for the keyword ISO and select the View we created earlier and drag it to the right plane
I select both PDF and CSV and click Save
Run the newly created report
Click Run
Select the Object – this could be a datacenter, cluster, vCenter or the entire vSphere World.
Then Click OK and the report will run
It will say Running until it completes then click on generated reports
Here is your report
You have the ability to download the PDF or CSV depending on how you like to perform your reporting. I always download both.
Summary:
As you can see there are a lot of parts to generate this custom report but it is worth it when it you need to pull this information rapidly. As always, I hope y’all found this helpful.