Creating User audit Reports faced error that "requestid" column does not exist in the view bipublish
RequestID Column missing in bipublisher_v view that stores user audit data for bi publisher.
Below is the query used by the model:-
SELECT
"RequestID",
"User",
"Report Path",
"Report Name",
"Report Type",
"Datamodel Path",
"Execution Type",
"Status",
"Message Text",
"Template",
"Locale",
"Template Type",
"OutputType",
"DataFileSize",
"Report Output Size",
"Report Start Time",
"Report End Time",
/*EXTRACT(DAY FROM "Total Report Execution Time") * 86400 + EXTRACT(HOUR FROM "Total Report Execution Time") * 3600 + EXTRACT(MINUTE FROM "Total Report Execution Time")* 60 + EXTRACT(SECOND FROM "Total Report Execution Time") * 1000 as "Total Report Time",*/
((EXTRACT(DAY FROM "Total Report Execution Time") * 86400000 + EXTRACT(HOUR FROM "Total Report Execution Time") * 3600000 + EXTRACT(MINUTE FROM "Total Report Execution Time")* 60000 + EXTRACT(SECOND FROM "Total Report Execution Time") * 1000)) as "Total Report Time",