Have you tried exporting the output of the command to a file, as in: export
node nodename filedata=backupactive preview=yes > filename-with-full-path

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
scottcorp
Sent: Thursday, September 06, 2007 5:29 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Full Backup Size Report

Thanks again to all - the "export node nodename filedata=backupactive
preview-yes" works, but I would love to get this into a SQL statement or
something so I dont have to look at the console or actlog to retrieve the
output.

I have been trying for a few hours to get this going but have never really
written a SQL code before, so needless to say I am not doing very well.

+----------------------------------------------------------------------
|This was sent by scottcorp AT fuse DOT net via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------

-----------------------------------------
Confidentiality Notice:
The information contained in this email message is privileged and
confidential information and intended only for the use of the
individual or entity named in the address. If you are not the
intended recipient, you are hereby notified that any dissemination,
distribution, or copying of this information is strictly
prohibited. If you received this information in error, please
notify the sender and delete this information from your computer
and retain no copies of any of this information.