Menu
I have some reports in SQL Server Reporting Services 2005 that I need to keep audit logs for. The audit log should include who ran what report with what parameters. I can't use Windows authentication.
What is the best way to log this information?
602
To access audit data, you can query that table directly, or you can use one of three views in the ReportServer database: ExecutionLog, ExecutionLog2, and ExecutionLog3.
The SSRS log file can be found in C:\Program Files\Microsoft SQL Server\MSRS12. SQL2014\Reporting Services\LogFiles (for SQL Server 2014). Log file settings control how verbose the log file content is and the maximum size that the file can grow to.
If you are still having trouble finding your SSRS error log files try the following: launch the SQL Server Error and Usage Report Settings application (Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Error and Usage Reporting) Click the Options button.
The previous comments were dead on accurate that you can mine the data from the ReportServer ExecutionLog table in SQL Server 2000/2005 or the ExecutionLogStorage table in SQL Server 2008. If you are using form-based authentication to access the reports instead of windows authentication, then you are probably passing some unique UserID, CompanyID, CustomerID, or other value as a parameter in your reports. If this is the case, then the built-in table captures the parameters already. If you aren't passing the unique user identifier as a parameter, then you will probably need to rely on logging report executions in your application itself.
181
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
