SQL Server - sys.certificates

select
   c.certificate_id                 certificate_id,
   c.name                           certificate_name,
   c.issuer_name                    certificate_issuer_name,
   c.subject,
   c.expiry_date,
   c.start_date,
   c.pvt_key_encryption_type_desc,
   c.cert_serial_number,
   c.is_active_for_begin_dialog,
   c.thumbprint,
   c.attested_by,
   c.key_length,
   p.name                           principal_name,
   p.type_desc                      principal_type,
   c.pvt_key_last_backup_date
from
   master.sys.certificates      c left join
          sys.server_principals p  on p.sid = c.sid