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 thewhere
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_atfrom godaddy_certificatewhere certificate_id = '14a42b6a799d4985b5c5e5e5f5d4249b';
select common_name, status, certificate_id, serial_number, created_at, organization, root_type, valid_start, valid_end, revoked_atfrom godaddy_certificatewhere 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_endfrom godaddy_certificatewhere certificate_id in ( '14a42b6a799d4985b5c5e5e5f5d4249b', '14a42b6a799d4985b5c5e5e5f5d4249f' ) and status = 'REVOKED';
select common_name, status, certificate_id, serial_number, created_at, valid_start, valid_endfrom godaddy_certificatewhere 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_phonefrom godaddy_certificatewhere 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_phonefrom godaddy_certificatewhere certificate_id = '14a42b6a799d4985b5c5e5e5f5d4249b';
Schema for godaddy_certificate
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
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. | |
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