question

stevehawk-1987 avatar image
0 Votes"
stevehawk-1987 asked MariosPhilippopoulos-9592 answered

How to know which user deleted a report from report manager

Hi All,
In the past few days one of the user accidentally deleted production reports. Luckily we have a dev environment that is in sync with the prod, i restored the report from dev. Is there a way we can find which userid did this? Is there a SQL that i can run to find it or any other way?
Thanks

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT edited

Hi @stevehawk-1987 ,
You could find the log of the corresponding time in the log folder, and open the text file and search this string Call to DeleteItemAction( to look for which user performed this operation.
The log files are located in C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles.
Regards,
Joy


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MariosPhilippopoulos-9592 avatar image
0 Votes"
MariosPhilippopoulos-9592 answered

Hi, the SSRS log files contain no information on when a report was deleted and by whom.
Here I am referring to files named as eg. "ReportingServicesService_2020_06_25_02_10_07.txt".
It would be nice if they did...

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.