First of all thanks for the help ...this is good learning for me.I ran the 
following select commands

>select node_name,sum(num_files),sum(physical_mb) from occupancy group by 
>node_name     
NODE_NAME               Unnamed[2]                            Unnamed[3]
------------------     -----------     ---------------------------------
DATACAP                   25528196                             353004.93

>select node_name,backup_mb,backup_copy_mb,archive_copy_mb from auditocc

NODE_NAME                BACKUP_MB     BACKUP_COPY_MB     ARCHIVE_COPY_MB
------------------     -----------     --------------     ---------------
DATACAP                      87774             260633                   0

Question: Does backup _copy_mb from audittocc  is the summ of all copy pools( 
copy LTO & DR pools)  or just the primary copy pool. First we use disk then 
copy it to LTO tape pool and then we copy from LTO tape pool to three DR pools 
which are in rotation for DR offsite. Looks like occupanct group is the TOTAL 
sum of all LTO pools correct ?


Thanks,
AShok Vats
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Bos, Karel
Sent: Wednesday, May 03, 2006 8:56 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] TASM 5.3.0.0 on AIX 5.3.0.0 quick question


Hi,

'select node_name,sum(num_files),sum(physical_mb) from occupancy group
by node_name' 


Regards,

Karel
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Vats.Ashok
Sent: woensdag 3 mei 2006 17:48
To: ADSM-L AT VM.MARIST DOT EDU
Subject: TASM 5.3.0.0 on AIX 5.3.0.0 quick question

Hi All,

We need to find how much storage is being used by each TSM client. I get
reports which indicate how much data is being backed up by each tsm
client but I am not able to find how much data is being stored for each
client. Is there any query or select statement I can use to get the info
from TSM ?

Thanks,
Ashok