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