You are not logged in.
Pages: 1
Dear Team
We have Audit Log where we get the reports which are fetched by the user. Is there any way to find whether the report fetch is from which Teamspace.
We required data of Teamspace Name from which report is fetched.
Regards,
Hardik pandya
Offline
Dear Team,
Awaiting for the reply.
Regards,
Hardik
Offline
I am also looking for a way to add a Teamspace name to my Audit logs. I have the below SQL but it doesn't seem performant
Select a.report_id , R.NAME_FIELD Report_Name, a.Report_Start, a.Report_end, a.action , a.Final_Report_Status, rs_user.username User_Name, rs_user.firstname, rs_user.lastname from
(SELECT (Select p1.value from RS_AUDIT_LOG_PROPERTY P1
where P1.KEY_FIELD in ( 'report' )
and p1.log_entry_id = start.entity_id ) Report_id, start.user_id ,
start.date_field Report_Start , final.date_field Report_End, final.action ,
Case when final.action = 'END_REPORT_EXECUTION' then 'SUCCESS' when final.action = 'REPORT_EXECUTED_FAILED' then 'FAIL' end Final_Report_Status
FROM
(SELECT E.*, P.KEY_FIELD, P.VALUE --R.NAME_FIELD, rs_user.username
FROM RS_AUDIT_LOG_ENTRY E
JOIN RS_AUDIT_LOG_PROPERTY P ON E.ENTITY_ID = P.LOG_ENTRY_ID AND E.ACTION IN ('BEGIN_REPORT_EXECUTION') AND P.KEY_FIELD in ( 'uuid' )
and e.date_field >= to_date(${From_Date}, 'yyyy-mm-dd')
and e.date_field < to_date(${To_Date} , 'yyyy-mm-dd')
) start left join
(SELECT DISTINCT e.action, e.DATE_FIELD, P.VALUE
FROM RS_AUDIT_LOG_ENTRY E,
RS_AUDIT_LOG_PROPERTY P
WHERE E.ENTITY_ID = P.LOG_ENTRY_ID AND E.ACTION IN ('END_REPORT_EXECUTION','REPORT_EXECUTED_FAILED') AND P.KEY_FIELD in ( 'uuid' )
) final on start.VALUE = final.VALUE
where final.value is not null
order by final.DATE_FIELD desc )a INNER JOIN RS_REPORT R ON a.Report_id = CAST(R.ID AS VARCHAR)
INNER JOIN rs_user rs_user ON a.user_id = rs_user.id
Last edited by aditi.raiter (2019-10-17 21:43:06)
Offline
I am also looking to see if this SQL can be modified to tell me if the report is scheduled and with the report recipients.
https://forum.reportserver.net/viewtopic.php?id=1548
Last edited by aditi.raiter (2019-10-17 21:47:52)
Offline
Pages: 1