Post reply

Reporting from multiple servers and databases

  • April 21, 2016 at 12:28 pm

    #306661

    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

  • April 24, 2016 at 10:32 pm

    #1874150

    Wow nobody replied to me ?

  • April 25, 2016 at 2:22 am

    #1874167

    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