Table: net_certificate

select
  *
from
  net_certificate
where
  domain = 'steampipe.io';

select
  domain,
  AGE(not_after, current_timestamp) as time_until_expiration
from
  net_certificate
where
  domain = 'steampipe.io';

select
  domain,
  not_before,
  not_after
from
  net_certificate
where
  domain = 'steampipe.io'
  and not_before < current_timestamp
  and not_after > current_timestamp;

select
  domain,
  not_before,
  not_after
from
  net_certificate
where
  domain = 'steampipe.io'
  and revoked;

select
  domain,
  ocsp ->> 'status' as revocation_status,
  ocsp ->> 'revoked_at' as revoked_at
from
  net_certificate
where
  domain = 'steampipe.io';

select
  domain,
  not_before,
  not_after,
  signature_algorithm
from
  net_certificate
where
  domain = 'steampipe.io'
  and signature_algorithm like any (array [ '%SHA1%', '%MD2%', '%MD5%' ]);