query report server db for artifacts and datasource connections

[gregHM]

anyone have a report or template for querying the report server db and collecting info on all the reports and data source connections used on the report server?

[KBO]

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...

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!

[gregHM]

thank you kathrin, this helps a lot !