• Why not just use a query to join the relevant catalogs and produce the cert and encryption key info in use

    SELECTdek.create_date
    , dek.regenerate_date
    , dek.modify_date
    , dek.set_date
    , dek.opened_date
    , dek.key_algorithm
    , dek.key_length
    , dek.encryptor_type
    , dek.encryptor_thumbprint
    , c.[name]
    , c.[subject]
    , c.[start_date]
    , c.[expiry_date]
    FROM sys.dm_database_encryption_keys dek
    INNER JOIN master.sys.certificates c
    ON dek.encryptor_thumbprint = c.thumbprint
    WHERE database_id = db_id()

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉