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

2011-04-05 Thread Dan Langille
On Mar 30, 2011, at 10:20 PM, Dan Langille wrote: > On Mar 30, 2011, at 4:46 PM, Rodrigo Renie Braga wrote: > >> 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 >> Ful

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

2011-03-30 Thread Dan Langille
On Mar 30, 2011, at 4:46 PM, Rodrigo Renie Braga wrote: > 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. B

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

2011-03-30 Thread Kleber Leal
You can start from below. select Level,sum(JobBytes) from Job group by Level; Kleber 2011/3/30 Rodrigo Renie Braga > 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 Ful

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

2011-03-30 Thread Rodrigo Renie Braga
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 sh