query weekly and monthly backups backup size

[Crowzz]

Good Afternoon

I need help getting our weekly and monthly backup size. Thanks to another tread i got the daily SQL query. Any help will be much appreciated.

 

[Trident]

Hi,
I am not sure I understand what you need?

Do you want sum of backups last week and last month? Or just the amount stored weekly/monthly?

We do a collect of backup from occ/desupstats every day can query those exports upon need.

You can also query summary table if that has a long enough retention. Numbers may be off, as it shows bytes transmitted, even if the backup fails or gets retransmitted.

 

[Crowzz]

Good morning!

We would like to get the Sum of backups for the week, then look at the month. I would like to look at each month if that's possible. If its not possible, thats ok.

Thanks for the help!

 

[Trident]

Hi,

I would recommend that you once a day extract q occ / q dedupstats and put those numbers into a spreadsheet, influx or any db. Then you can extract all the data from that db.

I guess some 3rd party reporting tools can do the same.

 

[Crowzz]

Sounds good, thanks for the help!