ReportServer Forum

hardik.pandya

Member

Registered: 2018-12-06

Audit Log Teamspace name

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

hardik.pandya

Member

Registered: 2018-12-06

Re: Audit Log Teamspace name

Dear Team,

Awaiting for the reply.

Regards,

Hardik

aditi.raiter

Member

Registered: 2018-05-01

Re: Audit Log Teamspace name

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)

aditi.raiter

Member

Registered: 2018-05-01

Re: Audit Log Teamspace name

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)