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.
Change Requests available through the 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.
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 any letter or specific attribute such as VMware Tools or Change requests:
Click on the field to add it to the list:
Click on EXPORT to submit the task.
Follow up the progress and download 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 tools_running_status tools_version change_requests --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
Related articles
University of Toronto - Since 1827