Collect data with central management servers and keep them in local table

I have 50 servers. I manage them from a central management server on SQL Server 2014 Enterprise Edition. I don't use repository.

I could open a query and get result for each one at the same time. But I want to do it in an automated way, like a job, to collect data from each server and store/handle it locally.

Is this possible and if so, how?

Surely you can automate via CMS as explained in Automate Your Central Management Server Registrations (SQL Server Central, free registration required), which I've used and works well in 2012 and should be the same for 2014 as mentioned:



-
Script 03_populate_cms_folders_from_inventory.sql could be scheduled as a SQL Agent job to regularly refresh the CMS folder
contents

-
Adding a section to [dbo].[ap_CMS_Populate_CMS_folder] to allow for SQL 2014 could be done (though I haven’t tested it)


Therefore by running the stored procedures from above article at the desired frequency via SQL Server Agent you can gather the data at your local table and later query for same.

One more way of doing this (apart from CMS) is to use Data Collector, which has quite significant changes in 2014 as explained in the article which also will help you automate the process.

Adding: Also you can use both as explained in:

Centralize Your Database Monitoring Process (SimpleTalk)

I hope the above articles/methods will help you in automating the tasks.

StackExchange Database Administrators Q#125728, answer score: 2