I have a jump\terminal server to administer 100 SQL Servers and want to evaluate my locally created policies across all the servers by using the Central Management Server but WITHOUT:
- creating the policies on the target servers and
- using the SSMS.
I need it to be run either with Powershell or T-SQL, doesn't really matter. I was trying to achieve this by iterating through a CSV file for each line holding the hostnames or by querying msdb.dbo.sysmanagement_shared_registered_servers
system table but so far no luck. Any way to accomplish this feat?