Flexible Central Management Server(CMS) query tool
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.