Export VM Details to Excel

[RasmusPerjans]

Hello,

We are fairly new to the Proxmox environment, coming from VMware previously.
We are using a Proxmox Cluster to host VMs for our customers use, and we bill our customers after their used VM resources.

It there an easy way to export a list of all VM and their associated VM resources (CPU core count, RAM, Disk total amount), preferably xlsx or csv.

Thanks alot!
Have a great day everyone!

 

[fabian]

no, but the config files are plain text so should be easy enough to parse.

alternatively, use the API:
- /cluster/resources => list of guests and other entities, including which node they are on
- /nodes/NODE/qemu/VMID/config to get a VM config
- /nodes/NODE/lxc/VMID/config to get a CT config

https://pve.proxmox.com/pve-docs/api-viewer/index.html#/nodes/{node}/lxc/{vmid}/config
https://pve.proxmox.com/wiki/Proxmox_VE_API

 

[RasmusPerjans]

Not sure im really following, where would i access the API and how, via one of the PVE hosts?
Any recommended command syntax for that to begin with?
Haven´t used this kind of protocol / access before.

 

[fabian]

see the second link - you can access the API using bindings in various languages (most commonly you'd use an API token, also explained on the same page).

alternatively, you can also read the guest configs directly, or use pct/qem CLI tools to script.

 

[bbgeek17]

pvesh get cluster/resources --type vm -o json|jq -r '(.[0] | keys_unsorted) as $keys | $keys, map([.[ $keys[] ]])[] | @csv'

---

Blockbridge : Ultra low latency all-NVME shared storage for Proxmox - https://www.blockbridge.com/proxmox

 

[RasmusPerjans]

pvesh get cluster/resources --type vm -o json|jq -r '(.[0] | keys_unsorted) as $keys | $keys, map([.[ $keys[] ]])[] | @csv'

---

Blockbridge : Ultra low latency all-NVME shared storage for Proxmox - https://www.blockbridge.com/proxmox

That command didnt work, syntax error, but i managed to export all VM info to a JSON file, then converted to excel with excel.
pvesh get cluster/resources --type vm --human-readable 1 -o json > report.json

It isn´t perfect but i solves the problem at the moment, we will look into integrating PVE via API to our PSA in the near future for report automation.

 

[bbgeek17]

That command didnt work, syntax error, but i managed to export all VM info to a JSON file, then converted to excel with excel.

works fine for me, perhaps you have older software or lost a quote..

root@proxmox7-nvme1:~# qm create 199
root@proxmox7-nvme1:~# qm create 299
root@proxmox7-nvme1:~# qm create 399
root@proxmox7-nvme1:~# qm create 499
root@proxmox7-nvme1:~# pvesh get cluster/resources --type vm -o json|jq -r '(.[0] | keys_unsorted) as $keys | $keys, map([.[ $keys[] ]])[] | @csv'
"cpu","disk","diskread","diskwrite","id","maxcpu","maxdisk","maxmem","mem","name","netin","netout","node","status","template","type","uptime","vmid"
0,0,0,0,"qemu/199",1,0,536870912,0,"VM 199",0,0,"proxmox7-nvme1","stopped",0,"qemu",0,199
0,0,0,0,"qemu/299",1,0,536870912,0,"VM 299",0,0,"proxmox7-nvme1","stopped",0,"qemu",0,299
0,0,0,0,"qemu/399",1,0,536870912,0,"VM 399",0,0,"proxmox7-nvme1","stopped",0,"qemu",0,399
0,0,0,0,"qemu/499",1,0,536870912,0,"VM 499",0,0,"proxmox7-nvme1","stopped",0,"qemu",0,499

---

Blockbridge : Ultra low latency all-NVME shared storage for Proxmox - https://www.blockbridge.com/proxmox