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:

   Open

   

    

4. To add more fields, just type any letter or specific attribute such as VMware Tools or Change requests:

   Open

   

5. Click on the field to add it to the list:

6. Click on EXPORT to submit the task.

7. Follow up the progress and download 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 tools_running_status tools_version change_requests --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