Reporting from multiple servers and databases

  • Hi Guys,

    I need to create a SSRS report which pulls database information from multiple servers.

    I have created central management servers with those 50+ servers and can query all those servers at once but how can i do same in a SSRS report?

    Query pulls data from msdb, master, model etc databases.

    I need to integrate that SSRS report in windows application later on.

    Thanks

  • Wow nobody replied to me ?

  • Hi,

    I think, you had to create 50+ datasources to use them in the reports.

    Or, are you able to store the result of the query in a table on the central management server?

    Kind regards,

    Andreas

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply