Flexible Central Management Server(CMS) query tool

18 Oct, 2025

I created this tool because, in my opinion, SQL Server Management Studio (SSMS) lacks the flexibility needed to work efficiently with Central Management Server (CMS). This tool provides enhanced control and convenience, allowing you to:

Define custom filters for databases
Exclude specific SQL Server instances
Exclude Always On secondary replicas
Save query results to a CSV file for easy import into Excel and further analysis
Execute queries containing multiple batches

It’s free, open source and available in my GitHub here.

#Powershell #Tsql