Home Forums SQL Server 2008 SQL Server Newbies Run a query against registered servers and insert results into table RE: Run a query against registered servers and insert results into table

  • Hi,

    So many years later, im not sure what i did back then, but now i just use PowerShell. load SQLPS module connect to the CMS Server query the msdb to get the list of servers and then loop through saving the results to a table or excel or what ever i need.

    I can supply a example script if anyone wants something to start with.