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.

1. Login to https://vss-portal.eis.utoronto.ca

2. Click on the gear icon at the top-right corner

   

    to expand the menu.

3. Select VM Inventory and a window will show up listing a few default fields:

   

4. To add more fields, just type it for instance typing "VMware Tools" will show something like:

5. Select the field as desired in order to add it to the list:

   

6. To submit the task, click on EXPORT

7. Follow up the report by going to the request history section.
   

   

8. When the report file is ready, click on the icon. 
   

Step-by-step guide using the VSS CLI

1. Login to https://vss-cli.eis.utoronto.ca with your VSS Credentials or use your local VSS CLI install.

2. Submit an inventory report with the vss-cli compute inventory mk command as follows:

   vss-cli compute inventory mk vmtRunning vmtVersion --format csv

3. Download inventory report:

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

4. 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

   
   

Related articles