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

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

    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

    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.
    Best regards,

    0 comments No comments