steampipe plugin install godaddy

Table: godaddy_certificate - Query GoDaddy Certificates using SQL

GoDaddy Certificate is a digital certificate used to secure websites and enable HTTPS. These certificates are issued by GoDaddy, a popular web hosting company and domain registrar. GoDaddy Certificates provide encryption, data integrity, and authentication, ensuring secure communication between a client and the server.

Table Usage Guide

The godaddy_certificate table provides insights into GoDaddy Certificates. As a security analyst, you can leverage this table to gather detailed information about each certificate, including its common name, issuer, serial number, and validity period. This can aid in managing and monitoring the security of your web applications and services hosted on GoDaddy.

Important Notes

  • You must specify the certificate_id in the where clause to query this table.

Examples

Basic info

Discover the segments that are related to a specific GoDaddy certificate. This query can be used to gain insights into the status, validity period, and revocation details of a certificate, which is beneficial for managing and tracking your SSL certificates.

select
common_name,
status,
certificate_id,
serial_number,
created_at,
organization,
root_type,
valid_start,
valid_end,
revoked_at
from
godaddy_certificate
where
certificate_id = '14a42b6a799d4985b5c5e5e5f5d4249b';
select
common_name,
status,
certificate_id,
serial_number,
created_at,
organization,
root_type,
valid_start,
valid_end,
revoked_at
from
godaddy_certificate
where
certificate_id = '14a42b6a799d4985b5c5e5e5f5d4249b';

List of revoked certificates

Discover the segments that contain revoked certificates to maintain the security and integrity of your network. This can be particularly useful in identifying potential vulnerabilities or malicious activities.

select
common_name,
status,
certificate_id,
serial_number,
created_at,
valid_start,
valid_end
from
godaddy_certificate
where
certificate_id in (
'14a42b6a799d4985b5c5e5e5f5d4249b',
'14a42b6a799d4985b5c5e5e5f5d4249f'
)
and status = 'REVOKED';
select
common_name,
status,
certificate_id,
serial_number,
created_at,
valid_start,
valid_end
from
godaddy_certificate
where
certificate_id in (
'14a42b6a799d4985b5c5e5e5f5d4249b',
'14a42b6a799d4985b5c5e5e5f5d4249f'
)
and status = 'REVOKED';

Get contact details of a specific certificate

This query is used to gather detailed contact information related to a specific certificate from GoDaddy. This can be particularly useful when you need to reach out to the certificate holder for any updates or issues.

select
common_name,
contact ->> 'Email' as contact_email,
contact ->> 'Fax' as contact_fax,
contact ->> 'NameFirst' as contact_first_name,
contact ->> 'NameLast' as contact_last_name,
contact ->> 'Organization' as contact_organization,
contact ->> 'Phone' as contact_phone
from
godaddy_certificate
where
certificate_id = '14a42b6a799d4985b5c5e5e5f5d4249b';
select
common_name,
json_extract(contact, '$.Email') as contact_email,
json_extract(contact, '$.Fax') as contact_fax,
json_extract(contact, '$.NameFirst') as contact_first_name,
json_extract(contact, '$.NameLast') as contact_last_name,
json_extract(contact, '$.Organization') as contact_organization,
json_extract(contact, '$.Phone') as contact_phone
from
godaddy_certificate
where
certificate_id = '14a42b6a799d4985b5c5e5e5f5d4249b';

Schema for godaddy_certificate

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
certificate_idtext=The unique identifier of the certificate request. Only present if no errors returned.
common_nametextThe common name of certificate.
contactjsonbContact details of the certificate.
created_attimestamp with time zoneThe date the certificate was ordered.
denied_reasontextReason specified if certificate order has been denied.
organizationjsonbDetails of the organization that owns the certificate.
periodbigintValidity period of order. Specified in years.
product_typetextCertificate product type.
progressbigintPercentage of completion for certificate vetting.
revoked_attimestamp with time zoneThe revocation date of certificate (if revoked).
root_typetextRoot type of the certificate.
serial_numbertextThe unique number of certificate (if issued or revoked).
serial_number_hextextThe hexadecmial format of serial number of the certificate(if issued or revoked).
slot_sizetextNumber of subject alternative names(SAN) to be included in certificate.
statustextStatus of certificate. Valid values are PENDING_ISSUANCE, ISSUED, REVOKED, CANCELED, DENIED, PENDING_REVOCATION, PENDING_REKEY, UNUSED, and EXPIRED.
subject_alternative_namesjsonbSpecifies subject alternative names set for the certificate.
titletextTitle of the resource.
valid_endtimestamp with time zoneThe end date of the certificate's validity (if issued or revoked).
valid_starttimestamp with time zoneThe start date of the certificate's validity (if issued or revoked).

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- godaddy

You can pass the configuration to the command with the --config argument:

steampipe_export_godaddy --config '<your_config>' godaddy_certificate