How to find who deleted a Folder on SQL Server Reporting Services?

Question

Hello,

We have a Folder on SQL Server Reporting Services (2019 Version) allowing multiple users access to manage the Reports and folder. Recently, someone deleted the whole folder, and we cannot determine who did it.

We have tried to look at the logs at the following locations, but that didn't help. Surprisingly, all the previous logs related to the reports under the deleted folder were also erased from these ExecutionLogs.

SELECT * FROM ReportServer.dbo.ExecutionLog

SELECT * FROM ReportServer.dbo.ExecutionLog3

C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles

SQL Logs

We have no idea what other options we have to find who deleted this folder. Any help/leads are greatly appreciated.

We are obviously working on limiting the Folder management access to limited people moving forward, but we would like to know who deleted it.

Answer 1

Hi @Akhilesh Neerukonda

I found this similar thread for you, maybe you can use it as a reference: https://learn.microsoft.com/en-us/answers/questions/119527/how-to-know-which-user-deleted-a-report-from-repor.

Best regards,

Aniya

Answer 2

SSRS don't log such operations, like creating folders/reports or deleting of them.

Must have been a user with the rights to delete items = content manager and admins