query report server db for artifacts and datasource connections

Hi gregHM ,

that really individual ;).

You find all information on the Report Server DB under ExecutionLog3.

On the following link you can see what you finde in this table. I think that are the Informations you'll need.

https://docs.microsoft.com/de-de/sql/reporting-services/report-server/report-server-executionlog-and-the-executionlog3-view?view=sql-server-ver15

I can look for one of my old monitoring reports If this will help :).

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!