Bacula Backup: List storage used by Client and Pool
Ein SQL Query welches aus der Bacula Mysql DB den Platzverbrauch pro Backup Client listet:
Dieses SQL Query kann in
/etc/bacula/scripts/query.sqleingefügt werden:
# 25
:List storage used by client and pool
SELECT Client.Name AS Client, Pool.Name as Pool,
sum(Job.JobFiles) as Files, sum(Job.JobBytes) as Bytes
FROM Client, Job, Pool
WHERE Job.ClientID = Client.ClientID and Job.PoolID = Pool.PoolID
GROUP by Pool.Name, Client.ClientID
ORDER by Client.Name, Pool.Name;Folgender Output entsteht dadurch:
+--------------------------+----------------+-----------+-------------------+
| Client | Pool | Files | Bytes |
+--------------------------+----------------+-----------+-------------------+
| Nsatellit-fd | File | 0 | 0 |
| Nsatellit-fd | daily | 0 | 0 |
| Nsatellit-fd | tape-monthly | 133,508 | 66,927,276,685 |
| Nsatellit-fd | tape-yearly | 53,022 | 19,818,750,039 |
| asterisk-primary-fd | File | 0 | 0 |
| asterisk-primary-fd | daily | 0 | 0 |
| asterisk-primary-fd | daily-backup01 | 15 | 45,777 |
| asterisk-primary-fd | tape-monthly | 13,801 | 16,033,807 |
| asterisk-primary-fd | tape-weekly | 6,903 | 8,036,499 |
| asterisk-primary-fd | tape-yearly | 2,260 | 2,626,523 |
| asterisk-stby-fd | File | 0 | 0 |
| asterisk-stby-fd | daily | 0 | 0 |
| asterisk-stby-fd | daily-backup01 | 73 | 943,823 |
| asterisk-stby-fd | tape-monthly | 15,169 | 49,796,279 |
| asterisk-stby-fd | tape-weekly | 7,587 | 24,940,423 |
| asterisk-stby-fd | tape-yearly | 2,479 | 8,187,252 |
| athene-fd | daily | 1,741,056 | 296,543,931,113 |
| athene-fd | monthly | 1,769,477 | 166,889,715,044 |
| athene-fd | tape-monthly | 7,273,334 | 619,423,047,359 |
| athene-fd | tape-weekly | 3,650,312 | 338,811,362,698 |
| athene-fd | tape-yearly | 1,138,190 | 92,350,892,977 |
