How to create a VM Inventory Report

Introduction

Inventory reports are useful to provide an offline overview of your virtual machines. When you submit an inventory report request, a CSV or JSON file will be generated with the selected attributes.

Step-by-step guide using the VSS Portal

The VSS Portal only supports CSV format. To submit a VM inventory report in JSON format, please use the VSS CLI.

Login to https://vss-portal.eis.utoronto.ca
Click on the gear icon at the top-right corner
to expand the menu.
Select VM Inventory and a window will show up listing a few default fields:
To add more fields, just type it for instance typing "VMware Tools" will show something like:
Select the field as desired in order to add it to the list:
To submit the task, click on EXPORT
Follow up the report by going to the request history section.
When the report file is ready, click on the icon.

Step-by-step guide using the VSS CLI

Login to https://vss-cli.eis.utoronto.ca with your VSS Credentials or use your local VSS CLI install.
Submit an inventory report with the vss-cli compute inventory mk command as follows:
```
vss-cli compute inventory mk vmtRunning vmtVersion --format csv
```

Download inventory report:

vss-cli compute inventory dl <id>
file                : ./34ad21c5-d341-4078-811a-e782ac04f5b2.csv

Use any tool like csvfix, Excel, Numbers or OpenOffice to load the data

csvfix printf -fmt "%s %s %s"  34ad21c5-d341-4078-811a-e782ac04f5b2.csv
vmtVersion vmtRunning name
guestToolsCurrent guestToolsRunning 1712T-loving_colden_2
guestToolsNotInstalled guestToolsNotRunning 1610Q-cocky_torvalds_12

How to create a VM Inventory Report

Introduction

Step-by-step guide using the VSS Portal

Step-by-step guide using the VSS CLI

Related articles