How to create a VM Inventory Report

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:
   

   For more information about the available inventory properties, please visit Inventory#Properties.

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. 

   A copy of the generated report will be stored in your personal space available in https://vskey-stor.eis.utoronto.ca under the inventory directory.

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. Initialize VSS CLI with vss-cli configure mk:
   

    Expand source

   vss-cli configure mk
   Endpoint [https://vss-api.eis.utoronto.ca]:
   Username []: username
   Password:
   Repeat for confirmation:

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

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

4. Download inventory report:

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

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