Get-DbaConnectedInstance

Synopsis

Returns SQL Server instances currently cached in the dbatools connection pool

Description

Shows all SQL Server connections that are currently active or cached in your PowerShell session. When you connect to instances using dbatools commands like Connect-DbaInstance, those connections are stored in an internal cache for reuse. This command reveals what’s in that cache, including connection details like whether pooling is enabled and the connection type (SMO server objects vs raw SqlConnection objects). Use this to track active connections before cleaning them up with Disconnect-DbaInstance or to troubleshoot connection-related issues in long-running scripts.

Syntax

Get-DbaConnectedInstance
    [<CommonParameters>]

Examples

Example: 1

PS C:\> Get-DbaConnectedInstance

Gets all connected SQL Server instances

Example: 2

PS C:\> Get-DbaConnectedInstance | Select *

Gets all connected SQL Server instances and shows the associated connectionstrings as well

Outputs

PSCustomObject

Returns one object per cached connection in the dbatools connection pool, containing details about each active or recently used SQL Server connection.

Default display properties (via Select-DefaultView):

• SqlInstance: The SQL Server instance identifier (computer\instance or server name)
• ConnectionType: The .NET type of the connection object (e.g., Microsoft.SqlServer.Management.Smo.Server or System.Data.SqlClient.SqlConnection)
• ConnectionObject: The actual connection object used internally by dbatools
• Pooled: Boolean indicating whether connection pooling is enabled for this connection

Additional properties available:

• ConnectionString: The connection string used to establish the connection (with credentials redacted for security) Use Select-Object * to view all properties including the full ConnectionString.