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: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
>


--
Hello World.                                    David Bronder - Systems Admin
Segmentation Fault                                     ITS-SPA, Univ. of Iowa
Core dumped, disk trashed, quota filled, soda warm.   david-bronder AT uiowa 
DOT edu