The following SELECT statement retrieves the view for QryLogExceptionsV:
SELECT * from DBC.QryLogExceptionsV;
The query returns the following result:
ProcID 16383 CollectTimeStamp 2004-06-21 16:38:34.21 QueryID 201205134619838011 UserName TEST1 SessionID ? RequestNum ? LogicalHostID 1 AcctString DBC WDID ? OpEnvID ? SysConID ? ClassificationTime ? ExceptionTime 2004-06-21 17:38:34.21 ExceptionValue ? ExceptionAction ? NewWDID ? ExceptionCode 3,152 ExceptionSubCode ? ErrorText No access allowed, For all requests, For user TEST1, Regulation applies from 00:00 to 24:00 ExtraInfo ? RuleID ? WarningOnly ? RejectionCat ?