dbatools is a free PowerShell module with over 180 SQL Server administration, best practice and migration commands included.


Get-DbaDatabaseEncryption

Returns a summary of encryption used on databases based to it. Shows if a database has Transparent Data encryption, any certificates, asymmetric keys or symmetric keys with details for each.

Examples

List all encryption found on the instance by database.

Get-DbaDatabaseEncryption -SqlServer DEV01

List all encrption found in MyDB.

Get-DbaDatabaseEncryption -SqlServer DEV01 -Database MyDB

Author

This command was created by Stephen Bennett. You can find Stephen blogging at sqlnotesfromtheunderground.wordpress.com.

Get-Help

From PowerShell, execute Get-Help Get-DbaDatabaseEncryption -Detailed for more information on this function.

Source Code

Want to see the source code? View Get-DbaDatabaseEncryption.ps1 on GitHub
 

Related commands