Re: [Bacula-users] Bacula size/statistics

2006-01-30 Thread Frank Sweetser
On Mon, Jan 30, 2006 at 06:23:43PM +, Martin Simmons wrote: > Yes, that's good on PostgreSQL too. I used "in" there before I realized it > needed sorting and limiting. Perfect - thanks for the fixed query! I've attached the updated version of the script here and uploaded it to the wiki. --

Re: [Bacula-users] Bacula size/statistics

2006-01-30 Thread Martin Simmons
> On Mon, 30 Jan 2006 11:51:45 -0500, Frank Sweetser <[EMAIL PROTECTED]> > said: > > On Mon, Jan 30, 2006 at 03:15:54PM +, Martin Simmons wrote: > > TotalBytes and TotalFiles don't work because the SchedTime is not unique and > > clients can have multiple filesets (which are not uniqu

Re: [Bacula-users] Bacula size/statistics

2006-01-30 Thread Frank Sweetser
On Mon, Jan 30, 2006 at 03:15:54PM +, Martin Simmons wrote: > TotalBytes and TotalFiles don't work because the SchedTime is not unique and > clients can have multiple filesets (which are not unique either). It also > counts non-backups jobs (restore, verify). > > Maybe something this would be

Re: [Bacula-users] Bacula size/statistics

2006-01-30 Thread Martin Simmons
> On Sun, 29 Jan 2006 16:41:20 -0500, Frank Sweetser <[EMAIL PROTECTED]> > said: > > I've noticed that one of the recurring questions, especially from new users, > is "how large" existing bacula installations are. This can encompas number > of clients being backed up, the amount of data,

[Bacula-users] Bacula size/statistics

2006-01-29 Thread Frank Sweetser
I've noticed that one of the recurring questions, especially from new users, is "how large" existing bacula installations are. This can encompas number of clients being backed up, the amount of data, and how large the catalog gets. To try and gather up some quantitative data on this, I hacked up