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:[EMAIL PROTECTED] > On Behalf Of Fawad Baig > Sent: 07 November 2006 15:09 > To: ADSM-L@VM.MARIST.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