Any built-in method to export to a CSV or excel Spreadsheet the Summary Listing for each HOST or a overall DATACENTER Sumary?

[user11655]

I have looked aroung in PDM and in Proxmox VE# 9.2.2 and did not see anyway to export like the summary tab to a CSV or Excel Spreadsheet.

 

[cwt]

For a cluster you can get all node resources with:

pvesh get /cluster/resources --type node --output-format json

An example for a csv export (package jq needed):

pvesh get /cluster/resources --type node --output-format json | \
jq -r '
["Node","Status","CPU %","Cores","RAM used GiB","RAM total GiB","Disk used GiB","Disk total GiB"],
(.[] | [
 .node,.status,
 (((.cpu // 0)*100)|round),
 .maxcpu,
 (((.mem // 0)/1073741824*100)|round/100),
 (((.maxmem // 0)/1073741824*100)|round/100),
 (((.disk // 0)/1073741824*100)|round/100),
 (((.maxdisk // 0)/1073741824*100)|round/100)
]) | @csv' > pve-summary.csv

 

[user11655]

For a cluster you can get all node ressorces with:

pvesh get /cluster/resources --type node --output-format json

An example for a csv export (package jq needed):

pvesh get /cluster/resources --type node --output-format json | \
jq -r '
["Node","Status","CPU %","Cores","RAM used GiB","RAM total GiB","Disk used GiB","Disk total GiB"],
(.[] | [
 .node,.status,
 (((.cpu // 0)*100)|round),
 .maxcpu,
 (((.mem // 0)/1073741824*100)|round/100),
 (((.maxmem // 0)/1073741824*100)|round/100),
 (((.disk // 0)/1073741824*100)|round/100),
 (((.maxdisk // 0)/1073741824*100)|round/100)
]) | @csv' > pve-summary.csv

Well Alright..glad there are smart people in this world..Thanks.