Taylor, David wrote: > > 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.
Without actually writing up any code, I'd offer a couple tips for improving on the below. First, run a single select statement and and save the output to a file; this reduced processing load on the TSM server. Include the node_name and domain_name fields in the select. You can then pull whatever data you need from that file much more quickly. Second, use the -TABdelimited or -COMMAdelimited option on the dsmadmc run to make the output more easily machine-parsable. Between those two things, you can easily run multiple canned or one-off reports on the same data, or you can import the data into another app (e.g. Excel or MySQL) and work with it however you like. Having the domain_name included allows you to run reports by policy domain as well as node name. > ------------------------- > 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 > -- Hello World. David Bronder - Systems Admin Segmentation Fault ITS-SPA, Univ. of Iowa Core dumped, disk trashed, quota filled, soda warm. [EMAIL PROTECTED]