steampipe 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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
acme_dns_errortextACME DNS-01 error.
acme_dns_fqdntextACME DNS-01 TXT entry FQDN.
acme_dns_valuetextACME DNS-01 TXT entry value.
app_idtextID of the application where the domain belong.
app_nametext=Name of the app.
canonicalbooleanThe domain is the canonical domain of this application.
idtext=Unique ID identifying the domain.
lets_encryptbooleanThe domain is using a Let’s Encrypt certificate.
lets_encrypt_statustextLet’s Encrypt certificate generation status.
nametextHostname your want to associate with the app.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
sslbooleanFlag if SSL with a custom certificate is enabled.
ssl_statustextSSL certificate status (pending, success, error).
tls_certtextSubject of the submitted certificate.
tls_keytextPrivate key type and length.
validitytimestamp with time zoneOnce a certificate has been submitted, display the validity of it.