Get-DbaProcess - Add information about endpoint and DAC

[andreasjordan]

Type of Change

• [ ] Bug fix (non-breaking change, fixes # )
• [x] New feature (non-breaking change, adds functionality, fixes # )
• [ ] Breaking change (affects multiple commands or functionality, fixes # )
• [ ] Ran manual Pester test and has passed (.\tests\manual.pester.ps1)
• [ ] Adding code coverage to existing functionality
• [ ] Pester test is included
• [ ] If new file reference added for test, has is been added to github.com/dataplat/appveyor-lab ?
• [ ] Unit test is included
• [ ] Documentation
• [ ] Build system

Purpose

I added information about the used endpoint and if it's the DAC (dedicated admin connection) endpoint to support analyzing problems with commands that need a DAC. This way we can easily tell if there is already an open DAC to the instance.

Commands to test

$dacProcess = Get-DbaProcess -SqlInstance SQL01 | ? IsDac
if ($dacProcess) {
    Write-Warning -Message "There is currently an open DAC with SPID $($dacProcess.Spid) from host $($dacProcess.HOST)."
    $dacProcess | Format-List *
}

[potatoqualitee]

very nice! thank you 🙇🏼