hi Friends,
Here is the example Scenario:
An SSRS Paginated Report has 2 data sources.
Data Source 1 (Shared Data source which is Sql Server based)
Data Source 2 (Expression based custom data source)
The expression used in the Data Source 2 may also refer to some linked server.
Requirement:
Extract the data sources details like the connection string, Username (that is used in the connection string), any linked servers involved details
Can anyone please help or provide a query which extracts these details from the Sql Server Audit tables ?