Get-Connection

DBSystems: Lists active SimplySQL database connections

Script

#Requires -Version 5.0
#Requires -Modules SimplySQL

[CmdLetBinding()]
Param(
    [switch]$ShowAll,
    [string]$ConnectionName = "DefaultConnection"
)

Import-Module SimplySQL

try {
    if ($ShowAll) {
        $result = Get-SqlConnection -All -ErrorAction Stop
    } else {
        $result = Get-SqlConnection -ConnectionName $ConnectionName -ErrorAction Stop
    }
    
    Write-Output $result
} catch {
    throw
}

Customize

ShowAll switch

Off

If set, returns all active SQL connections

ConnectionName string

Specifies the name of the connection to retrieve (Defaults to 'DefaultConnection')