function Get-MSSQLLinkPasswords{

  <#
.SYNOPSIS
Extract and decrypt MSSQL linked server passwords.

Author: Antti Rantasaari 2014, NetSPI
License: BSD 3-Clause

.DESCRIPTION
Get-MSSQLLinkPasswords extracts and decrypts the connection credentials for all linked servers that use SQL Server authentication on all local MSSQL instances.

.INPUTS
None

.OUTPUTS
System.Data.DataRow

Returns a datatable consisting of MSSQL instance name, linked server name, user account, and decrypted password.

.EXAMPLE
C:\PS> Get-MSSQLLinkPasswords

Instance Linkserver User Password
——– ———- —- ——–
SQLEXPRESS SQLSERVER2 test test
SQLEXPRESS DEV-SQL dev Passw0rd01!
SQL2012 DEV-SQL dev Passw0rd01!
SQL2012 WEBDB sa W3bDB$4P4ssw0rd
SQL2012 VAULT sa !@#Sup3rS3cr3tP4$$w0rd!!$$

.NOTES
For successful execution, the following configurations and privileges are needed:
- DAC connectivity to MSSQL instances
- Local administrator privileges (needed to …