gistfile1.sql

select 
  database_id as 'Database ID', name as 'Database Name', 
  CASE encryption_state
  WHEN 0 THEN 'No database encryption key present, no encryption'
  WHEN 1 THEN 'Unencrypted'
  WHEN 2 THEN 'Encryption in progress'
  WHEN 3 THEN 'Encrypted'
  WHEN 4 THEN 'Key change in progress'
  WHEN 5 THEN 'Decryption in progress'
  WHEN 6 THEN 'Protection change in progress'
  END as Status
from 
  sys.dm_database_encryption_keys e
join 
  sys.sysdatabases d 
on 
  e.database_id = d.dbid