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
Last activity: Apr 28, 2023, 12:06 AM