AllRestarts
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;';
);