I'm not sure if you can do this with a select. One thing you could try
would be an export node, with filedata=ALLActive and preview=yes. 


Matt.

> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] 
> On Behalf Of Fawad Baig
> Sent: 07 November 2006 15:09
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: [ADSM-L] select statement for All active files for a node
> 
> Hi
> 
> I need a select statement to calculate total GB for all the "ACTIVE"
> files backed up for a node. any thoughts anyone?
> 
> --
> Regards,
> 
> Fawad Baig
> 
> 
>  
> 


This email is confidential and may be privileged. If you are not the intended 
recipient please notify the sender immediately and delete the email from your 
computer. 

You should not copy the email, use it for any purpose or disclose its contents 
to any other person.
Please note that any views or opinions presented in this email may be personal 
to the author and do not necessarily represent the views or opinions of Digica.
It is the responsibility of the recipient to check this email for the presence 
of viruses. Digica accepts no liability for any damage caused by any virus 
transmitted by this email.

UK: Phoenix House, Colliers Way, Nottingham, NG8 6AT UK
Reception Tel: + 44 (0) 115 977 1177
Support Centre: 0845 607 7070
Fax: + 44 (0) 115 977 7000
http://www.digica.com

SOUTH AFRICA: Building 3, Parc du Cap, Mispel Road, Bellville, 7535, South 
Africa
Tel: + 27 (0) 21 957 4900
Fax: + 27 (0) 21 948 3135
http://www.digica.com