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 
>> 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...
> 
> The OP contacted me on IRC and I suggested they post here.  They were asking 
> me about this page:
> 
>  https://services.unixathome.org/bacula/
> 
> SELECT P.Name as name,
>       pg_size_pretty( sum( coalesce( m.volbytes, 0 ) )::bigint) as size,
>       count(M.mediaid) as tape_count
>  FROM pool P, media M
> WHERE P.PoolId = m.poolid
>   AND P.name IN ('Incrementals', 'Differentials', 'Fulls')
> GROUP BY 1
> ORDER BY P.name

I believe the OP contacted me because of this webpage: 
https://services.unixathome.org/bacula/

This webpage now has the ability to display the SQL associated with each output.
------------------------------------------------------------------------------
Xperia(TM) PLAY
It's a major breakthrough. An authentic gaming
smartphone on the nation's most reliable network.
And it wants your games.
http://p.sf.net/sfu/verizon-sfdev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users