Bacula-users

Re: [Bacula-users] SQL Query to get size of all Full/Diff Backups

2011-03-30 17:19:34
Subject: Re: [Bacula-users] SQL Query to get size of all Full/Diff Backups
From: Kleber Leal <kleber.leal AT gmail DOT com>
To: bacula-users <bacula-users AT lists.sourceforge DOT net>
Date: Wed, 30 Mar 2011 18:16:07 -0300
You can start from below.

select Level,sum(JobBytes) from Job group by Level;

Kleber

2011/3/30 Rodrigo Renie Braga <rodrigorenie AT gmail DOT com>
Hello list.

Can someone send me the SQL Query to get the size that all my Full, Diff and Inc backups are currently consuming? In my config, I have 5 Pools that store Full Backup tapes, the same happens for Diff and Inc Backups. But if you send me a SQL Query.

I'm going to use this to know when should I get more tapes for my Storage...

Thanks!

------------------------------------------------------------------------------
Create and publish websites with WebMatrix
Use the most popular FREE web apps or write code yourself;
WebMatrix provides all the features you need to develop and
publish your website. http://p.sf.net/sfu/ms-webmatrix-sf

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users


------------------------------------------------------------------------------
Create and publish websites with WebMatrix
Use the most popular FREE web apps or write code yourself; 
WebMatrix provides all the features you need to develop and 
publish your website. http://p.sf.net/sfu/ms-webmatrix-sf
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
<Prev in Thread] Current Thread [Next in Thread>