WFMReportAudit

These query subjects are unique to the WFMReportAudit package.

Actions by object

Metadata model reference Database reference
User Name COGIPF_USERLOGON.USERNAME
Time Stamp COGIPF_ACTION.TIME STAMP
Operation COGIPF_ACTION.OPERATION
Target Type COGIPF_ACTION.TARGET TYPE
Target Path COGIPF_ACTION.TARGET PATH
Status COGIPF_ACTION.STATUS

Run Reports

Metadata model reference Database reference
User Name COGIPF_USERLOGON.USERNAME
Report Name COGIPF_RUNREPORT.REPORT NAME
Report Type COGIPF_RUNREPORT.TARGET TYPE
Report Search Path COGIPF_RUNREPORT.REPORT PATH
Session ID COGIPF_RUNREPORT.SESSION ID
Request ID COGIPF_RUNREPORT.REQUEST ID
Execution Time COGIPF_RUNREPORT.RUN TIME
Time Stamp COGIPF_RUNREPORT.TIME STAMP
Package COGIPF_RUNREPORT.PACKAGE
Status COGIPF_RUNREPORT.STATUS
Error Details COGIPF_RUNREPORT.ERROR DETAILS

User Logins

Metadata model reference Database reference
User Name COGIPF_USERLOGON.USERNAME
Logon Time COGIPF_USERLOGON.TIME STAMP
Session ID COGIPF_USERLOGON.SESSION ID
Logoff Operation COGIPF_USERLOGOFF.LOGOFF OPERATION
Logoff Time COGIPF_USERLOGOFF.TIME STAMP
Session Duration User Logins.Logoff Time - User Logins.Logon Time

View Reports

Metadata model reference Database reference
User Name COGIPF_USERLOGON.USERNAME
Report Name "if (COGIPF_VIEWREPORT.REPORT PATH = 'null' ) then ('Unsaved report') else if (COGIPF_VIEWREPORT.REPORT PATH = '') then ('Unsaved report') else if ( position('/report', COGIPF_VIEWREPORT.REPORT PATH)>0) then (substring (COGIPF_VIEWREPORT.REPORT PATH, position('/report', COGIPF_VIEWREPORT.REPORT PATH)+15, position('', substring (COGIPF_VIEWREPORT.REPORT PATH, position('/report', COGIPF_VIEWREPORT.REPORT PATH)+15)) -2)) else if ( position('/interactiveReport', COGIPF_VIEWREPORT.REPORT PATH)>0) then (substring (COGIPF_VIEWREPORT.REPORT PATH, position('/interactiveReport', COGIPF_VIEWREPORT.REPORT PATH)+26, position('', substring (COGIPF_VIEWREPORT.REPORT PATH, position('/interactiveReport', COGIPF_VIEWREPORT.REPORT PATH)+26)) -2)) else ('Unsaved report')"
Report Type upper(substring (COGIPF_VIEWREPORT.TARGET TYPE , 1, 1) )+ lower(substring(COGIPF_VIEWREPORT.TARGET TYPE , 2, character_length(COGIPF_VIEWREPORT.TARGET TYPE ) - 1))
Report Format if (COGIPF_VIEWREPORT.REPORT FORMAT = 'SearchResult for COGIPF_REPORTFORMAT') then ('Format unspecified') else (COGIPF_VIEWREPORT.REPORT FORMAT )
Report Search Path trim (COGIPF_VIEWREPORT.REPORT PATH)
Time Stamp COGIPF_VIEWREPORT.TIME STAMP
Error Details COGIPF_VIEWREPORT.ERROR DETAILS
Package "if (COGIPF_VIEWREPORT.PACKAGE = 'null') then (' ') else if (COGIPF_VIEWREPORT.PACKAGE = '' ) then (' ') else if(position('/package', COGIPF_VIEWREPORT.PACKAGE)>0) then(substring (COGIPF_VIEWREPORT.PACKAGE, position('/package', COGIPF_VIEWREPORT.PACKAGE)+16, position('', substring (COGIPF_VIEWREPORT.PACKAGE, position('/package', COGIPF_VIEWREPORT.PACKAGE)+16))-2) ) else (substring (COGIPF_VIEWREPORT.PACKAGE , 1, character_length( COGIPF_VIEWREPORT.PACKAGE)))"
Status upper(substring (COGIPF_VIEWREPORT.STATUS , 1, 1) )+ lower(substring(COGIPF_VIEWREPORT.STATUS , 2, character_length(COGIPF_VIEWREPORT.STATUS ) - 1))