VMWare vRealize Operations: Create Custom View and Report to Identify Virtual Machine’s with Mounted ISO

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

Machine generated alternative text:
nager 
Views 
Home 
Dashboards

Go to Dashboards > Views > New View

Machine generated alternative text:
x 
v 1. Name and Description 
Name: 
Description: 
CANCEL 
SAVE
Machine generated alternative text:
1. Name and Description 
Name: 
VM's with Mounted ISO 
Description: 
This view is for identifyingl virtual machines with a 
mounted ISO.

Provide the View a name and description to help find in the future.

Machine generated alternative text:
2 Presentation 
List 
Summary 
Trend 
Distribution 
Image 
List 
List views provide tabular data about 
objects in the monitored environment that 
correspond to the selected view. 
Configuration 
Items per page: SO 
Top result count: 
Click to select the subject for which the 
> 3 Subjects 
view applies. 
> 4 _ Data 
> 5. Visibility

Select list under Presentation

Machine generated alternative text:
> 1. Name and Description 
> 2 Presentation 
3 Subjects 
Virtual Machine 
Add subject 
Group by: 
Nane 
> 4 _ Data 
> 5. Visibility 
V 
Preview source: 
Column I 
Object Name 1 
Object Name 2 
Object Name 3 
Object Name 4 
Object Name 5 
Data 
Sample data 
Column 2 
Property Value 1 
Property Value 2 
Property Value 3 
Property Value 4 
Property Value 5 
Column 3 
Value 1 
Value 2 
Value 3 
Value 4 
Value S 
Time Settings 
Filter 
Column 4 
Value 1 
Value 2 
Value 3 
Value 4 
Value S 
Summary 
Breakdown by 
Transformation 
Drag the data to include in the view. 
Click to select what metrics / 
in the view. 
Select preview source„. 
I - IS of IS items 
Configuration 
Select a metric or property to 
configure. 
CANCEL 
2 
SAVE

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

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.

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

Then drag and drop that property into the view plane

Machine generated alternative text:
Data 
Data 
Time Settings 
Breakdown by 
Transformation 
Filter 
Summary 
SummarylGuest Operating SystemlG„_ Current 
Drag the data to include in the view. 
Configuration 
General: 
Metric name: 
Metric Iaær 
units: 
Sort order: 
I - IS of IS items 
SummarylGuest 
Summary'Guest O 
None 
Transformation: 
Current 
No Timestamp 
Show advanced settings

This section is good and next we click on Time Settings

Machine generated alternative text:
Data 
Time Settings 
Breakdown by 
Filter 
Summary 
Configure Time Range for Data 
Time Range Mode: O Basic 
C) Advanced 
Currently selected date range: From Apr 28, 2020 PM to 4:19:11 PM 
O Relative Date Range 
Last 7 
Days 
C) Specific Date Range 
Start om 
C) Absolute Date Range 
CANCEL 
SAVE

I leave it at 7 days

Machine generated alternative text:
Data 
Breakdown by 
Time Settings 
Breakdown by 
Filter 
Summary 
Add interval breakdown column (see data for column 
settings) 
Add instance breakdown column (see data for column 
settings)

I leave Breakdown by blank

Machine generated alternative text:
Data 
Time Settings 
Breakdown by 
Filter 
Summary 
Virtual Machine filter 
Select the Object Type that matches all of the following 
criteria: 
Metrics 
Add another criteria set 
Pick a metric 
Virtual Machine 
--Select- 
Metric value 
Add Reset

We need to change Metrics to Properties

Machine generated alternative text:
Data 
Time Settings 
Breakdown by 
Filter 
Summary 
Virtual Machine filter 
Select the Object Type that matches all of the following 
Virtual Machine 
criteria: 
Properties 
Add another criteria set 
*rty value 
Disable unexposed features - unity-unityactiv_. 
Disable unexposed features - 
Disable unexposed features - unitypush 
Disable unexposed features - versionget (isol„ 
Disable unexposed features - versionset (solm 
Disable virtual disk shrink (isolationtc:olsdisk_. 
Disable virtual disk (isolationtc:olsdisk 
Disable VIX messages from the VM 
Disconnect CD-ROM 
Disconnect floppy drive 
Disconnect CD 
Add Reset 
CANCEL 
SAVE 
-ROM

Navigate to Configuration > Security > Disconnect CD-ROM

Under Select put : is

Under Property Value type: false

Machine generated alternative text:
Data 
Time Settings 
Breakdown by 
Filter 
Summary 
Virtual Machine filter 
Select the Object Type that matches all of the following 
criteria: 
Properties 
Add another criteria set 
Virtual Machine 
Configuration SecuritylDisconn. is 
false 
Add Reset 
CANCEL 
SAVE

Then click save

How to Turn Metric into Report

Machine generated alternative text:
Views 
Reports

On the left plane you can click Reports

Machine generated alternative text:
Reports 
Report Templates 
NEW TEMPLATE 
Generated Reports 
ACTIONS v

Select New Template

Machine generated alternative text:
1. Name and Description 
Name: 
VM's with Mounted ISO 
Description: 
This report will display all virtual machines that 
have a mounted ISOI

Give the Report a name and description

Machine generated alternative text:
2 Views and Dashboards 
Data type: 
Ni > All Filters 
VM's with Mounted ISO 
Views 
I - lot I items

Filter for the keyword ISO and select the View we created earlier and drag it to the right plane

Machine generated alternative text:
VM's with Mounted ISO - Edit Report Template 
> 1. Name and Description 
> 2 Views and Dashboards 
3 Formats 
PDF 
x 
V 
Views and in the report (sample data) 
VM's with Mounted ISO 
Colorization 
x 
GCH3d for sharing with people who need to print it 
out 
GCH3d for exporting data to be used by other data 
analysis applications. 
> 4 _ Layout Options 
CANCEL 
SAVE

I select both PDF and CSV and click Save

Run the newly created report

Machine generated alternative text:
VM's with Mounted ISO 
Run 
Schedule 
Edit 
Clone 
Export

Click Run

Machine generated alternative text:
Select an Object 
All Objects 
AWS Adapter 
Container 
EP Ops Adapter 
Http Post 
Loglnsight 
Microsoft Azure Adapter 
SDDC Health Adapter 
Service Discovery Adapter 
vCenter Adapter 
vCenter Actions Adapter 
x 
VOAAdapter 
Name : vCenter Python 
@ vRealize Automation Adap er .x 
vRealize Log Insight Adapter 
vRealize Operations Adapter 
vRealizeOpsMgrApl 
CANCEL

Select the Object – this could be a datacenter, cluster, vCenter or the entire vSphere World.

Then Click OK and the report will run

Machine generated alternative text:
VM's with Mounted ISO 
Generated rechorts (6) Schedules (O)

It will say Running until it completes then click on generated reports

Machine generated alternative text:
Reports 
Report Templates 
ACTIONS v 
Completion Date/Time 
: 15 seconds ago 
Generated Reports 
Report Name 
VM's with Mounted ISO 
Subject 
Virtual Machine

Here is your report

Machine generated alternative text:
Download

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.

Leave a Reply