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:[EMAIL PROTECTED] On Behalf Of Avy Wong Sent: Monday, April 07, 2008 4:09 PM To: ADSM-L@VM.MARIST.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. **********************************************************************