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?
Sql-server – How to handle audit logging with SSRS
reporting-servicesreportingservices-2005sql serversql-server-2005
Related Topic
- Sql-server – the best way to auto-generate INSERT statements for a SQL Server table
- When to use RDLC over RDL reports
- Sql – How to do an UPDATE statement with JOIN in SQL Server
- SSRS with Custom Web UI
- Sql – How to share an image between projects in Microsoft SQL Server Reporting Services 2005
- Sql-server – Insert multiple rows WITHOUT repeating the “INSERT INTO …” part of the statement
- Sql-server – SQL variable to hold list of integers
Best Answer
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.