Thanks this worked great.

Karla Ross




Lawrence Clark <Larry_Clark AT THRUWAY.STATE.NY DOT US>@VM.MARIST.EDU> on
05/30/2003 12:01:50 PM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

Sent by:    "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To:    ADSM-L AT VM.MARIST DOT EDU
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

>>> keross AT US.IBM DOT COM 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