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


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.


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


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


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