SSRS: Report Data logging process/audit trail

1. Does SSRS is J-Sox Compliant, an application must have audit trail feature. For Reporting printing, it should facilitate reports' data logging process. 

2. Information like WHO and WHEN printed the report and WHAT data was viewed?

June 30th, 2015 8:34am

Hi AjayKumar_MIND,

According to your description, you want to know if SSRS has an audit logging ability, right?

In Reporting Services, it has built-in audit logging which called execution log. After we enable report execution logging in report server properties, Reporting Services stores execution data in several tables in the report server database. We can view the report server execution log using methods below:

  • A sample script file called Createtables.sql that creates a new execution log database specifically for viewing log data.
  • A sample SQL Server Integration Services package called RSExecutionLog_Update.dtsx that extracts data from the internal report server database and copies it to the sample execution log database that you create.
  • A collection of sample reports that retrieves data from the execution log database and displays it in reports that you view on a report server.

Reference:
Querying and Reporting on Report Execution Log Data
How to Audit Report Execution in SSRS
Reporting Services LogViewer

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu

Free Windows Admin Tool Kit Click here and download it now
June 30th, 2015 11:36pm

Hello Qiuyun,

Thanks for updating on this.

Let me go thru with referenced articles and then I come back to you on this.

Best Regards, Ajay

July 1st, 2015 3:24am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics