15.10 - ListRestart_Logon_Events - Teradata Database

ListRestart_Logon_Events

REPLACE MACRO SystemFE.ListRestart_Logon_Events

 (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 80;';

echo 'set NULL as "-";';

echo 'set separator 2;';

echo 'set pagelength 60;';

echo 'set suppress on 3,4;';

echo 'set omit on 1,2;';

echo 'set heading "&DATE||(Crashable/logon-enabled Events)||&TIME//Between &1 and &2";';

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     TheDate between :fromdate and :todate

And       (Event_tag = 0331385500

           or  Event_tag = 0331389200

           or  (Event_tag = 340290000 AND text like '%logons are enabled%'))

Order By  TheDate, TheTime, Line;

);