turbot/net

steampipe plugin install netsteampipe plugin install net

Table: net_certificate

Certificate details for a domain.

Note: A domain must be provided in all queries to this table.

Examples

Certificate information

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

Time until the certificate expires

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

Check if the certificate is currently valid

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

.inspect net_certificate

Certificate details for a domain.

NameTypeDescription
chainjsonbCertificate chain.
common_nametextCommon name for the certificate.
countrytextCountry for the certificate.
dns_namesjsonbDNS names for the certificate.
domaintextDomain name the certificate represents.
email_addressesjsonbEmail addresses for the certificate.
ip_addressinetIP address associated with the domain.
ip_addressesjsonbArray of IP addresses associated with the domain.
is_cabooleanTrue if the certificate represents a certificate authority.
issuertextIssuer of the certificate.
issuing_certificate_urljsonbList of URLs of the issuing certificates.
localitytextLocality of the certificate.
not_aftertimestamp without time zoneTime when the certificate expires. Also see not_before.
not_beforetimestamp without time zoneTime when the certificate is valid from. Also see not_after.
organizationtextOrganization of the certificate.
oujsonbOrganizational Unit of the certificate.
public_key_algorithmtextPublic key algorithm used by the certificate.
serial_numbertextSerial number of the certificate.
signature_algorithmtextSignature algorithm of the certificate.
statetextState of the certificate.
subjecttextSubject of the certificate.