WFMReportAudit
These query subjects are exclusive to the WFMReportAudit metadata model.
| Query Subject | Comments | Package | Folder/ Namespace | Metadata Model Reference | Database Reference |
|---|---|---|---|---|---|
| Actions by Object | WFMReportAudit | Actions by Object > User Name | COGIPF_USERLOGON.USERNAME | ||
| Actions by Object > Time Stamp | COGIPF_ACTION.TIME STAMP | ||||
| Actions by Object > Operation | COGIPF_ACTION.OPERATION | ||||
| Actions by Object > Target Type | COGIPF_ACTION.TARGET TYPE | ||||
| Actions by Object > Target Path | COGIPF_ACTION.TARGET PATH | ||||
| Actions by Object > Status | COGIPF_ACTION.STATUS | ||||
| Run Reports | WFMReportAudit | Run Reports > User Name | COGIPF_USERLOGON.USERNAME | ||
| Run Reports > Report Name | COGIPF_RUNREPORT.REPORT NAME | ||||
| Run Reports > Report Type | COGIPF_RUNREPORT.TARGET TYPE | ||||
| Run Reports > Report Search Path | COGIPF_RUNREPORT.REPORT PATH | ||||
| Run Reports > Session ID | COGIPF_RUNREPORT.SESSION ID | ||||
| Run Reports > Request ID | COGIPF_RUNREPORT.REQUEST ID | ||||
| Run Reports > Execution Time | COGIPF_RUNREPORT.RUN TIME | ||||
| Run Reports > Time Stamp | COGIPF_RUNREPORT.TIME STAMP | ||||
| Run Reports > Package | COGIPF_RUNREPORT.PACKAGE | ||||
| Run Reports > Status | COGIPF_RUNREPORT.STATUS | ||||
| Run Reports > Error Details | COGIPF_RUNREPORT.ERROR DETAILS | ||||
| User Logins | WFMReportAudit | User Logins > User Name | COGIPF_USERLOGON.USERNAME | ||
| User Logins > Logon Time | COGIPF_USERLOGON.TIME STAMP | ||||
| User Logins > Session ID | COGIPF_USERLOGON.SESSION ID | ||||
| User Logins > Logoff Operation | COGIPF_USERLOGOFF.LOGOFF OPERATION | ||||
| User Logins > Logoff Time | COGIPF_USERLOGOFF.TIME STAMP | ||||
| User Logins > Session Duration | User Logins.Logoff Time - User Logins.Logon Time | ||||
| View Reports | WFMReportAudit | View Reports > User Name | COGIPF_USERLOGON.USERNAME | ||
| View Reports > 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')" | ||||
| View Reports > Report Type | upper(substring (COGIPF_VIEWREPORT.TARGET TYPE , 1, 1) )+ lower(substring(COGIPF_VIEWREPORT.TARGET TYPE , 2, character_length(COGIPF_VIEWREPORT.TARGET TYPE ) - 1)) | ||||
| View Reports > Report Format | if (COGIPF_VIEWREPORT.REPORT FORMAT = 'SearchResult for COGIPF_REPORTFORMAT') then ('Format unspecified') else (COGIPF_VIEWREPORT.REPORT FORMAT ) | ||||
| View Reports > Report Search Path | trim (COGIPF_VIEWREPORT.REPORT PATH) | ||||
| View Reports > Time Stamp | COGIPF_VIEWREPORT.TIME STAMP | ||||
| View Reports > Error Details | COGIPF_VIEWREPORT.ERROR DETAILS | ||||
| View Reports > 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)))" | ||||
| View Reports > Status | upper(substring (COGIPF_VIEWREPORT.STATUS , 1, 1) )+ lower(substring(COGIPF_VIEWREPORT.STATUS , 2, character_length(COGIPF_VIEWREPORT.STATUS ) - 1)) |