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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users