The following statement generates a report of all restarts and logon-enabled events for the last 11 days:
Exec ListRestart_Logon_Events(date-10,date);
The resulting report follows:
EXECUTE ListRestart_Logon_Events (date-10,date); *** Query completed. 17 rows found. 5 columns returned. 13/05/29 (Crashable/logon-enabled Events) 09:42 Between 2013-05-19 and 2013-05-29 Date Time Message Text -------- --------------- ------------------------------------------------------- 13/05/21 00:55:17.162969 13/05/21 00:55:17 Logons are enabled 13/05/26 03:06:04.232870 13/05/26 03:06:04 Logons are enabled 22:40:15.943210 13/05/26 22:40:15 Logons are enabled 13/05/27 00:39:52.300814 13/05/27 00:39:52 Logons are enabled 01:07:21.218686 13/05/27 01:07:21 Logons are enabled 01:16:14.637825 13/05/27 01:16:14 Logons are enabled