Thanks this worked great. Karla Ross
Lawrence Clark <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 05/30/2003 12:01:50 PM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: Subject: Re: Need select command to show how much is backed up By client: select node_name, sum(logical_mb) as Data_In_MB, sum(num_files) as Num_of_files from occupancy group by node_name order by node_name asc >>> [EMAIL PROTECTED] 05/30/03 12:34PM >>> I need a select command the will show me how much data is being backed up by my tsm server, can anyone help? Karla Ross
