16.20 - AllRestarts - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ SystemFE Macros

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Administration
featnum
B035-1103-162K
REPLACE MACRO SystemFE.AllRestarts
	(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 Events)||&TIME//Between &1 and      &2";';
Select    :Fromdate      (Format 'YYYY-MM-DD')
        , :Todate        (Format 'YYYY-MM-DD')
        , TheDate        (Title  'Date')
        , TheTime        (Title  'Time')
        , Text
From      DBC.Software_Event_Log
Where     TheDate between :fromdate and :todate
And       (Event_Tag = 0331385500 OR
           Event_Tag = 0331389200 )
Order By  TheDate, TheTime, Line;
 
echo 'set omit off;';
echo 'set heading "Total Restarts";';
Select    Count(*)            (Title 'Restarts')
From      DBC.Software_Event_Log
Where     TheDate between :fromdate and :todate
And       Line = 1
And       (Event_Tag = 0331385500 OR
           Event_Tag = 0331389200);
 
echo 'set defaults;';
);