15.10 - DiskEvents - Teradata Database

Teradata Database SystemFE Macros

prodname

Teradata Database

vrm_release

15.00

15.10

REPLACE MACRO SystemFE.DiskEvents

 (Fromdate (date,               FORMAT 'YYYY-MM-DD'),

  Todate   (date, DEFAULT DATE, FORMAT 'YYYY-MM-DD')) AS

echo 'set defaults;';

echo 'set format on;';

echo 'set width 150;';

echo 'set NULL as "-";';

echo 'set separator 2;';

echo 'set pagelength 60;';

echo 'set omit on 1,2;';

echo 'set suppress on 3,4,5;';

echo 'set heading "&DATE||Disk Events Between &1 and &2||&TIME";';

Select   :Fromdate      (Format 'YYYY-MM-DD')

       , :Todate        (Format 'YYYY-MM-DD')

       , TheDate        (Title  'Date')

       , TheTime        (Title  'Time')

       , Text           (Title  'Message Text')

FROM   DBC.Software_Event_Log

Where  Event_Tag in (0331103600, 0331103800, 0331109400)

And    TheDate BETWEEN :fromdate AND :Todate

Order by TheDate, TheTime;

echo 'set defaults;';

);