The following statement generates a report of all restarts between January 1, 2013 and March 18, 2013:
exec AllRestarts('2013-01-01','2014-03-18');
The system displays a report similar to this:
exec AllRestarts('2013-01-01','2014-03-18'); *** Echo accepted. *** Total elapsed time was 1 second. *** Echo accepted. *** Echo accepted. *** Echo accepted. *** Echo accepted. *** Echo accepted. *** Echo accepted. *** Echo accepted. *** Echo accepted. *** Query completed. 4 rows found. 5 columns returned. 14/04/04 (Crashable Events) 11:45 Between 2013-01-01 and 2014-03-18 Date Time Message Text -------- --------------- ----------------------------------------------------------------- 14/03/14 16:54:28.912135 PDE: TPA restart initiated by this node, 001-01, for event 10198. 16:54:55.723604 PDE: TPA restart initiated by this node, 001-01, for event 10198. 14/03/17 14:39:29.013986 PDE: TPA restart initiated by this node, 001-01, for event 10198. 15:05:51.651466 PDE: TPA restart initiated by this node, 001-01, for event 10198. *** Echo accepted. *** Echo accepted. *** Query completed. One row found. One column returned. Total Restarts Restarts ----------- 4 *** Echo accepted.