To View List of Database Encryption Keys

security-audit
#database#encryption#security-audit
select * from sys.dm_database_encryption_keys

--or

SELECT DB_NAME(database_id)
 ,encryption_state = CASE
 WHEN encryption_state = 1
 THEN 'Unencrypted'
 WHEN encryption_state = 2
 THEN 'Encryption in progress'
 WHEN encryption_state = 3
 THEN 'Encrypted'
 WHEN encryption_state = 4
 THEN 'Key change in progress'
 WHEN encryption_state = 5
 THEN 'Decryption in progress'
 WHEN encryption_state = 6
 THEN 'Protection change in progress'
 WHEN encryption_state = 0
 THEN 'No database encryption key present, no encryption'
 END
 ,create_date
 ,encryptor_type
FROM sys.dm_database_encryption_keys