steampipe plugin install francois2metz/scalingosteampipe plugin install francois2metz/scalingo

Table: scalingo_domain

List domains associated to an app.

The scalingo_domain table can be used to query information about domains, and you must specify which application in the where or join clause using the app_name column.

Examples

List domains of an application

select
  name,
  ssl,
  canonical
from
  scalingo_domain
where
  app_name = 'caresteouvert-api';

Schema for scalingo_domain

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
acme_dns_error	text		ACME DNS-01 error.
acme_dns_fqdn	text		ACME DNS-01 TXT entry FQDN.
acme_dns_value	text		ACME DNS-01 TXT entry value.
app_id	text		ID of the application where the domain belong.
app_name	text	=	Name of the app.
canonical	boolean		The domain is the canonical domain of this application.
id	text	=	Unique ID identifying the domain.
lets_encrypt	boolean		The domain is using a Let’s Encrypt certificate.
lets_encrypt_status	text		Let’s Encrypt certificate generation status.
name	text		Hostname your want to associate with the app.
ssl	boolean		Flag if SSL with a custom certificate is enabled.
ssl_status	text		SSL certificate status (pending, success, error).
tls_cert	text		Subject of the submitted certificate.
tls_key	text		Private key type and length.
validity	timestamp with time zone		Once a certificate has been submitted, display the validity of it.