Sample Header Ad - 728x90

Run Policy Based Management On Central Management Server with Code

0 votes
1 answer
63 views
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: 1) creating the policies on the target servers and 2) 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?
Asked by Stackoverflowuser (1550 rep)
Apr 27, 2023, 01:23 PM
Last activity: Apr 28, 2023, 12:06 AM