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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
certificate_id	text	=	The unique identifier of the certificate request. Only present if no errors returned.
common_name	text		The common name of certificate.
contact	jsonb		Contact details of the certificate.
created_at	timestamp with time zone		The date the certificate was ordered.
denied_reason	text		Reason specified if certificate order has been denied.
organization	jsonb		Details of the organization that owns the certificate.
period	bigint		Validity period of order. Specified in years.
product_type	text		Certificate product type.
progress	bigint		Percentage of completion for certificate vetting.
revoked_at	timestamp with time zone		The revocation date of certificate (if revoked).
root_type	text		Root type of the certificate.
serial_number	text		The unique number of certificate (if issued or revoked).
serial_number_hex	text		The hexadecmial format of serial number of the certificate(if issued or revoked).
slot_size	text		Number of subject alternative names(SAN) to be included in certificate.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text		Status of certificate. Valid values are PENDING_ISSUANCE, ISSUED, REVOKED, CANCELED, DENIED, PENDING_REVOCATION, PENDING_REKEY, UNUSED, and EXPIRED.
subject_alternative_names	jsonb		Specifies subject alternative names set for the certificate.
title	text		Title of the resource.
valid_end	timestamp with time zone		The end date of the certificate's validity (if issued or revoked).
valid_start	timestamp with time zone		The 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