SSRS haw Can I check are reports was sent?

Question

I want know, which reports was send and to whom.

I want will create SQL which sent me raport with data.

Each day server sents about 60 report to others person.

Answer 1

You can get it from view(s) ExecutionLog in ReportServer database, request type = Subscription; see

https://learn.microsoft.com/en-us/sql/reporting-services/report-server/report-server-executionlog-and-the-executionlog3-view?view=sql-server-ver16

SELECT *
FROM ReportServer.dbo.ExecutionLog3 AS EL
WHERE RequestType = 'Subscription'

Answer 2

Hi @Artur Bogusławski

You can refer to this link: https://stackoverflow.com/questions/18960965/ssrs-subscriptions-how-to-view-all-report-recipients.

Hope it helps you.

Best regards,

Aniya