Do you have PERL5 and are you running on AIX? I have a script that produces this output if you like??
############################################################### # CLIENT BACKUP TOTALS # # FOR # # S02F03N01 TSM SERVER # # # # These Totals are from 00:01 to 23:59:59 for the given date # ############################################################### BACKUP DATE HOSTNAME DATA (MB) 10/28/2002 S02CWSP 49 10/28/2002 S02F02N01 3740 10/28/2002 S02F02N13 501 10/28/2002 S02F03N01 11 10/28/2002 S02F03N07 10 10/28/2002 S02F03N07DB2 941 10/28/2002 S02F03N09 12373 10/28/2002 S02F03N11 3805 10/28/2002 S02F04N07 125 10/28/2002 S02F04N09 677 10/28/2002 S02F04N11 1739 10/28/2002 S02F05N01 40 10/28/2002 S02F05N05 42 10/28/2002 S02F05N05DB2 1155 10/28/2002 S02F05N07 4478 10/28/2002 S02F05N09 863 10/28/2002 S02F05N13 2007 10/28/2002 S02F20N01 303 10/28/2002 S02F21N01 13161 --- "Fought,Tom" <[EMAIL PROTECTED]> wrote: > Request for sql script... > A while back there was a posting of a very useful report. > I have been able reproduce all the parts except for the one > below. > If anyone is aware of how to generate this content from the > TSM sql databases I would really appreciate it. > Thanks > Tom Fought > > > +--------------------------------------------------------------------------- > ------------------------------------------+ > & & > & > & 2.& TSM Backup Log the last 24 hours > & > & & > & > & & The following ifromation tells you how mutch data was sent over to > TSM the last 24 hours. & > & & The reason for this is for you to see if there is anything unusual > with the data transfer to the TSM Server. & > & & > & > & & Pay special attention to TDP product because they can say completed > in schedules but dont send anything over & > & & to TSM, because of some unknown error. > & > & & > & > & & This information alsow tells you how mutch data is sent over total > to the system & > & & > & > +--------------------------------------------------------------------------- > ------------------------------------------+ > > > > > NODE NAME DOMAIN PLATFORM > MBYTES CONECTIONS > ------------------ ------------------ ---------------- > ------------ ----------- > BAUG_CDB2 REKSTRAR DB2 > 12360.93 4 > FINGRANDI REKSTRAR WinNT > 8789.06 1 > VEFUR2_NOTES REKSTRAR WinNT > 8674.47 2 > PLUTO NYHERJI WinNT > 6730.55 2 > VIT TITAN DB2/6000 > 5929.64 1 > CODINN TITAN AIX > 4771.42 1 > NETV TITAN AIX > 3395.24 1 > AIXNOTES1 NYHERJI TDP Domino AIX > 3072.04 24 > BAUG_CWEBC REKSTRAR AIX > 2437.61 2 > TONLIST TITAN Linux86 > 1448.93 1 > SS_PDC REKSTRAR WinNT > 1369.52 3 > ISLENSKT REKSTRAR AIX > 1297.98 3 > QBRMS REKSTRAR OS400 > 1170.43 9 > EXMAIL1 REKSTRAR WinNT > 823.17 2 > SS_DOM REKSTRAR WinNT > 768.01 5 > ORION NYHERJI WinNT > 729.68 2 > FP TITAN WinNT > 702.99 2 > LUMUR_NAVISION REKSTRAR WinNT > 683.59 1 > ODINN TITAN AIX > 676.75 1 > AXEL NYHERJI WinNT > 668.59 2 > ISA1 REKSTRAR WinNT > 654.20 1 > VEFUR2 REKSTRAR WinNT > 614.36 2 > LYF_DOM REKSTRAR WinNT > 576.00 6 > AFRITARI REKSTRAR AIX > 551.97 2 > MENNT REKSTRAR WinNT > 481.82 2 > NTLYF1 REKSTRAR WinNT > 480.53 2 > GRANDIS01 REKSTRAR WinNT > 473.74 1 > REKILL NYHERJI WinNT > 434.84 1 > CNEO TITAN AIX > 421.29 1 > VEFUR3 REKSTRAR WinNT > 414.94 2 > SS_NOTES REKSTRAR WinNT > 402.67 2 > SURTUR REKSTRAR DB2/6000 > 387.13 3 > CTRINITY TITAN AIX > 337.09 1 > DC1 REKSTRAR WinNT > 330.57 2 > TIMASKRANING REKSTRAR WinNT > 307.26 1 > HEIM.IS REKSTRAR Linux86 > 254.30 2 > TS1 REKSTRAR WinNT > 249.79 1 > MAGNADUR TITAN SCO > 243.97 1 > GLYRNIR REKSTRAR WinNT > 227.74 1 > SOL NYHERJI WinNT > 211.18 2 > EXMAIL1_EXCHANGE REKSTRAR WinNT > 190.00 6 > GRIC2RAD TITAN Linux86 > 186.99 1 > MARS NYHERJI WinNT > 180.61 2 > SAPNSD NYHERJI WinNT > 175.80 2 > NOTES1 NYHERJI AIX > 154.95 1 > GYLFI NYHERJI WinNT > 150.00 2 > LOKI TITAN AIX > 144.20 1 > ETOP NYHERJI WinNT > 135.68 2 > NEPTUNUS NYHERJI WinNT > 134.43 2 > BAUG_EPLI REKSTRAR AIX > 110.31 1 > ITS1 NYHERJI WinNT > 94.29 2 > IDES2 NYHERJI WinNT > 94.25 2 > JONAS NYHERJI WinNT > 93.40 2 > MIKILL TITAN SCO > 85.81 1 > DIRECTOR NYHERJI WinNT > 80.36 2 > SIMASERVER1 NYHERJI WinNT > 72.17 2 > SAPRNP REKSTRAR WinNT > 68.36 2 > CTISERVER-01 NYHERJI WinNT > 54.54 2 > NEO TITAN AIX > 54.51 1 > SS_TSE2 REKSTRAR WinNT > 51.74 2 > SS_TSE1 REKSTRAR WinNT > 40.26 2 > ORACLE TITAN AIX > 19.39 1 > LUMUR REKSTRAR WinNT > 8.91 1 > SS1ADAL REKSTRAR WinNT > 8.24 1 > BAUG_BANANI REKSTRAR AIX > 3.09 1 > ? > > +------------------------------------------+ > & & > & Total data sent to TSM the last 24 hours & > & & > +------------------------------------------+ > > > DATE MBYTES CONNECTIONS > ---------- ------------ ----------- > 2002-04-22 76948.59 149 __________________________________________________ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2
