This one is not finished but this is a first draft ;)
In agent configuration on the node add this:
[ExternalTable/PBSBackup]
Command = proxmox-backup-manager task list --all --output-format json-pretty | jq -r '(map(keys) | add | unique) as $cols | map(. as $row | $cols | map($row[.])) as $rows | $cols, $rows[] | @tsv'
Separator = \t
InstanceColumns = Index
Description = Proxmox backup server status
PollingInterval = 320
Do a restart agent and then a config poll.
After that you should be able to go to Data Collection Configuration on that node and add a new Table.
Thank you for the Draft !
If this is your first time ;)
You will need to install on your Proxmox Backup Server
apt install jq
ELSE you will get this in the Last Value on PBSBackup
thread 'main' panicked at 'failed printing to stdout: Broken pipe (os error 32)', library/std/src/io/stdio.rs:1187:9
note: run with `RUST_BACKTRACE=1` environment variable to display a backtrace
If you try the command on the command line
PVE-PBS-Server# proxmox-backup-manager task list --all --output-format json-pretty | jq -r '(map(keys) | add | unique) as $cols | map(. as $row | $cols | map($row[.])) as $rows | $cols, $rows[] | @tsv'
-bash: jq: command not found
thread 'main' panicked at 'failed printing to stdout: Broken pipe (os error 32)', library/std/src/io/stdio.rs:1187:9
note: run with `RUST_BACKTRACE=1` environment variable to display a backtrace
Regards Dawid
Thanks for the update Dawid ;)