In answer to getting nightly backup volume, I use the following
(AIX/Korn shell) to get both total for the night and individual node's
data.  The reason for the loop on a single node is due to some
file-systems being so huge that run a simple "dsmc inc" would kill the
box - so I backup each file-system individually.


-------------------------  
cat $INPUTFILE | while read LINE; do
NODE=`echo $LINE | cut -f1 -d,`
   integer NODETOTAL=0
   dsmadmc -id=admin -pass=$TSMPWD "select entity,activity,bytes as
BYTES from summary where (activity='BACKUP' or activity='ARCHIVE') and
(end
_time between '$YESTERDAY 05:30:20' and '$TODAY 05:30:19') and
entity='$NODE' order by bytes desc" | grep $NODE | grep -v ANS8000I |
awk '{prin
t $3 }' |while read BACKUPVOL; do
     integer NODETOTAL=`expr $NODETOTAL + $BACKUPVOL`
   done
fi
printf "${LINE}${NODETOTAL},\n" >> $OUTPUTFILE
done
------------------------  

I'm sure that someone else has a single-line of code to do the same
thing, but this works for me.

HTH

David
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Avy Wong
Sent: Monday, April 07, 2008 4:09 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Stats

Hello,
      Can anyone tell me if there is a way/ query to find the following:


1.  total GB currently stored in tape library < == run audit license
first,
then 'q audit' , add all the Total storage used

2.   average nightly GB that are backed up <== ??

3.  average nightly GB that expire <==??

4.  Average  nightly GB of  TDP backup <==?? ( I think if I can find out
how on # 2, I can figure out # 4)



Thank you for your help.

Avy Wong
Business Continuity Administrator
Mohegan Sun
1 Mohegan Sun Blvd
Uncasville, CT 06382
(860)862-8164
(cell) (860)961-6976

**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept for the 
presence of computer viruses.

**********************************************************************