Running PowerShell command in Central Management Server

David C 191

I'm a PowerShell noob. I know I can run T-SQL commands against multiple servers in my Central Management Server. Can I run a PS cmdlet or function against multiple servers from within the CMS? When I click on any node in the CMS hierarchy, the "Start PowerShell" option is available. But when I run PowerShell in that way, and run a PS cmdlet in the window, it only runs against the local SQL Server. Thanks.

Cris Zhan-MSFT 6,631 Reputation points

2020-08-20T09:18:45.613+00:00

Hi,

I am also not familiar with PowerShell, but the T-SQL can do it when you click the "New Query" on the Central Management Server or server group node in the CMS hierarchy.

>>Can I run a PS cmdlet or function against multiple servers from within the CMS?

PowerShell should also be able to do this. please check following posts for reference:
https://serverfault.com/questions/807076/how-can-we-manage-multiple-servers-from-center-place

https://dba.stackexchange.com/questions/151533/list-the-cms-sql-server-instances-using-powershell

===============================================
If the response helped, do "Accept Answer" and upvote it.

Share via

Running PowerShell command in Central Management Server

Your answer