The following statement requests the software event log information for any event with a severity level of 50 (unrecoverable user error, no user restart):
SELECT TheDate, TheTime, Category, Severity FROM Software_Event_LogV Where Severity = ‘50’ ;
Result:
TheDate TheTime Category Severity -------- -------- -------- -------- 92/08/20 10:10:30 4 50