turbot/net_insights

Query: ssl_additional_certificate_record

Usage

powerpipe query net_insights.query.ssl_additional_certificate_record

Steampipe Tables

SQL

select
c ->> 'common_name' as "Common Name",
TO_CHAR((c ->> 'not_before')::timestamp, 'Dy, DD Mon YYYY HH24:MI:SS TZ') as "Valid From",
TO_CHAR((c ->> 'not_after')::timestamp, 'Dy, DD Mon YYYY HH24:MI:SS TZ') || ' (expires in ' || date_trunc('day', age((c ->> 'not_after')::timestamp, now())) || ')' as "Valid Until",
c ->> 'public_key_algorithm' || ' ' || (c ->> 'public_key_length')::text || ' bits' as "Key",
c ->> 'issuer_name' as "Issuer",
c ->> 'signature_algorithm' as "Signature Algorithm"
from
net_certificate,
jsonb_array_elements(chain) as c
where
domain = $1
order by domain;

Params

ArgsNameDefaultDescriptionVariable
$1domain_input

    Dashboards

    The query is used in the dashboards: