topic Re: Audit User Access in Report Server

Audit User Access

csteinberg — Fri, 26 Jan 2018 15:57:46 GMT

Hello,

We want to audit usage on Report Server. Who logs in and what reports they access.

Is that possible? Where do we see it?

Thanks.

Re: Audit User Access

Greg_Deckler — Fri, 26 Jan 2018 16:01:36 GMT

https://www.ultimatewindowssecurity.com/sqlserver/auditlog/default.aspx

https://www.ultimatewindowssecurity.com/sqlserver/auditlog/reporting.aspx

Re: Audit User Access

Anonymous — Mon, 29 Jan 2018 03:21:57 GMT

I've set up a report based on the report server database that looks at which users are running which reports and when. I based it on the information in this article:

https://www.sqlchick.com/entries/2011/2/6/querying-the-report-server-execution-log.html