Mike,
Sorry I'm fairly new to bacula, can you tell me how to
use the query.sql ?
Or where I can find some documentation so I can
find out.
Thanks in advance,
Caspar
> On
Fri, 04 Dec 2009, Caspar Smit might have said:
>
>>
>>
>> Hi all,
>>
>> I wondered if
there is a way to check how much
>> storage
>> space
a client (filedaemon) is using?
>>
>> Kind
>> regards,
>> Caspar
>> Smit
>
> I added this query to my query.sql file.
>
>
Mike
>
> # 20
> :List storage used by client and
pool
> SELECT Client.Name AS Client, Pool.Name as Pool,
>
sum(Job.JobFiles) as Files, sum(Job.JobBytes) as Bytes
> FROM
Client, Job, Pool
> WHERE Job.ClientID = Client.ClientID and
Job.PoolID = Pool.PoolID
> GROUP by Client.ClientID
>
ORDER by Client.Name;
>
------------------------------------------------------------------------------
Join us December 9, 2009 for the Red Hat Virtual Experience,
a free event focused on virtualization and cloud computing.
Attend in-depth sessions from your desk. Your couch. Anywhere.
http://p.sf.net/sfu/redhat-sfdev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
