Add-DbaRegServer View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Registers SQL Server instances to Central Management Server or Local Server Groups in SSMS
Description Registers SQL Server instances as managed servers within SSMS, either to a Central Management Server (CMS) for enterprise-wide management or to Local Server Groups for personal organization. This allows DBAs to centrally organize and quickly connect to multiple SQL Server instances from SSMS without manually typing connection details each time.
Add-DbaRegServerGroup View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Creates organizational server groups within SQL Server Central Management Server (CMS)
Description Creates new server groups in SQL Server Central Management Server to organize registered servers into logical hierarchies. This allows DBAs to group servers by environment, application, location, or any other classification system for easier management at scale. Supports nested group structures using backslash notation (Group\SubGroup) and automatically creates parent groups if they don’t exist.
Export-DbaRegServer View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Exports registered servers and registered server groups to file
Description Exports registered servers and registered server groups to file
Syntax Export-DbaRegServer [[-SqlInstance] <DbaInstanceParameter[]>] [[-SqlCredential] <PSCredential>] [[-InputObject] <Object[]>] [[-Path] <String>] [[-FilePath] <FileInfo>] [[-CredentialPersistenceType] <String>] [[-Group] <Object[]>] [[-ExcludeGroup] <Object[]>] [-Overwrite] [-EnableException] [<CommonParameters>] Examples Example: 1 PS C:\> Export-DbaRegServer -SqlInstance sql2008 Exports all Registered Server and Registered Server Groups on sql2008 to an automatically generated file name in the current directory
Get-DbaRegServer View Source Bryan Hamby (@galador) , Chrissy LeMaire (@cl) Windows, Linux, macOS Synopsis Retrieves registered SQL Server instances from SSMS, Azure Data Studio, and Central Management Server
Description Retrieves SQL Server instances from registered server configurations stored in SQL Server Management Studio (SSMS), Azure Data Studio, and Central Management Server (CMS). DBAs use registered servers to organize and quickly connect to multiple SQL Server instances across their environment.
Get-DbaRegServerGroup View Source Tony Wilhelm (@tonywsql) Windows, Linux, macOS Synopsis Retrieves server group objects from SQL Server Central Management Server (CMS) for organized server management.
Description Returns server group objects from Central Management Server, which are organizational containers that help DBAs manage multiple SQL Server instances in a hierarchical structure. Server groups allow you to categorize registered servers by environment, function, or any logical grouping that makes sense for your infrastructure.
Get-DbaRegServerStore View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Creates a RegisteredServersStore object for managing Central Management Server configurations
Description Creates a RegisteredServersStore object that serves as the foundation for working with SQL Server Central Management Server (CMS). This object provides access to server groups and registered servers stored in the CMS repository, allowing you to programmatically manage multiple SQL Server instances from a centralized location. When no SqlInstance is specified, it returns the local file store which contains your locally registered servers from SQL Server Management Studio.
Import-DbaRegServer View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Imports registered servers and server groups into SQL Server Central Management Server from XML files, other CMS instances, or custom objects
Description Imports registered servers and server groups into a SQL Server Central Management Server (CMS) from multiple sources including exported XML files, other CMS instances, or custom objects like CSVs. The function automatically creates missing server groups during import and supports importing to specific group locations within the CMS hierarchy.
Move-DbaRegServer View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Moves registered servers between groups within SQL Server Central Management Server (CMS)
Description Moves registered server entries from one group to another within Central Management Server hierarchy. This helps reorganize CMS structure when server roles change or you need to restructure your server groupings for better management. The function updates the CMS database to reflect the new group membership while preserving all server connection details and properties.
Move-DbaRegServerGroup View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Moves registered server groups to different parent groups within SQL Server Central Management Server (CMS)
Description Moves registered server groups to new locations within your Central Management Server hierarchy. This lets you reorganize your CMS group structure without using SQL Server Management Studio manually. You can move groups between different parent groups or relocate them to the root level, helping you maintain organized server collections as your environment grows or changes.
Remove-DbaRegServer View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Removes registered servers from SQL Server Central Management Server or local registered server groups.
Description Removes registered servers from SQL Server Central Management Server (CMS) or local registered server groups within SQL Server Management Studio. This command helps DBAs clean up outdated server registrations, remove decommissioned servers, or reorganize server inventory without manually navigating through SSMS interfaces.
You can remove servers by specifying individual server names, registered server display names, or entire groups.
dbatools