where to find the exection info when a user is removed from site settings in reporting service 2019 Native mode

XIAO YAN CHEN 1 Reputation point
2022-09-21T02:24:35.183+00:00

hi Team

we are using reporting service 2019 Native mode.
we want to find out users who were removed from site settings in the last N months , meaning users who were removed permission to access web portal.

but I got no luck to find the info in RSPortal_xxxx.log or ReportingServicesService_xxxx.log. either in ExceutionLogStorage table.

any advise on this, great thanks.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,823 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 41,101 Reputation points
    2022-09-21T06:10:37.313+00:00

    SSRS permission changes are not logged.
    You would have to implement an own solution, like frequently persist permission and compare them to current ones.

    0 comments No comments

  2. AniyaTang-MSFT 12,326 Reputation points Microsoft Vendor
    2022-09-21T06:46:11.83+00:00

    Hi @XIAO YAN CHEN
    Maybe you can use the ReportServer.Users table. This table contains details about access details for users of the report server.
    I did a test, I added the VP user in the site settings, and after deleting it, I can still find the user in the Users table.
    243279-2.png
    Best regards,
    Aniya

    0 comments No comments