{"id":232,"date":"2013-05-15T12:53:49","date_gmt":"2013-05-15T18:53:49","guid":{"rendered":"http:\/\/s1095387061.online-home.ca\/?p=232"},"modified":"2013-06-26T13:01:14","modified_gmt":"2013-06-26T19:01:14","slug":"mssql-tips-tip-9","status":"publish","type":"post","link":"https:\/\/databaserefresh.com\/blog\/mssql-tips-tip-9\/","title":{"rendered":"MSSQL Tips: Tip #9 \u2013 Creating a multi-server query SSRS report using Central Management Servers"},"content":{"rendered":"<p>In this tip I demonstrate how to create single SQL Server Reporting Services (SSRS) report that will display SQL Servers versions for all of  the SQL Servers that are registered in Central Management Server.<\/p>\n<p>Please read this MSSQL Tip:  &#8220;<a title=\"Creating a multi-server query SSRS report using Central Management Servers\" href=\"http:\/\/www.mssqltips.com\/sqlservertip\/2954\/creating-a-multiserver-query-ssrs-report-using-central-management-servers\/\" target=\"_blank\">Creating a multi-server query SSRS report using Central Management Servers<\/a>&#8220;.<\/p>\n<p>Check out all of my tips here: <a title=\"http:\/\/www.mssqltips.com\/sqlserverauthor\/94\/svetlana-golovko\/\" href=\"http:\/\/www.mssqltips.com\/sqlserverauthor\/94\/svetlana-golovko\/\" target=\"_blank\">http:\/\/www.mssqltips.com\/sqlserverauthor\/94\/svetlana-golovko\/<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this tip I demonstrate how to create single SQL Server Reporting Services (SSRS) report that will display SQL Servers versions for all of the SQL Servers that are registered in Central Management Server. Please read this MSSQL Tip: &#8220;Creating &hellip; <a href=\"https:\/\/databaserefresh.com\/blog\/mssql-tips-tip-9\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[12,13,3,33,30],"tags":[42,37,53,36],"class_list":["post-232","post","type-post","status-publish","format-standard","hentry","category-dba_checks","category-dba_doc","category-sql_server","category-sql-server-reporting-services","category-tips-sql_server","tag-mssqltips","tag-report","tag-sql-server-version","tag-ssrs"],"_links":{"self":[{"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/posts\/232","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/comments?post=232"}],"version-history":[{"count":4,"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/posts\/232\/revisions"}],"predecessor-version":[{"id":236,"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/posts\/232\/revisions\/236"}],"wp:attachment":[{"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/media?parent=232"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/categories?post=232"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/tags?post=232"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}