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
