steampipe plugin install francois2metz/gandisteampipe plugin install francois2metz/gandi

gandi_certificate gandi_domain gandi_forward gandi_livedns_record gandi_mailbox gandi_web_redirection

Table: gandi_livedns_record

The gandi_livedns_record table can be used to query information about your records and you must specify which domain in the where or join clause using the domain column.

Examples

List records of your domain

select
  rrset_name,
  rrset_type,
  rrset_values
from
  gandi_livedns_record
where
  domain = 'example.net';

List records with a specific name

select
  rrset_type,
  rrset_values
from
  gandi_livedns_record
where
  domain = 'example.net'
  and rrset_name = 'test';

List CNAME records

select
  rrset_name,
  rrset_values
from
  gandi_livedns_record
where
  domain = 'example.net'
  and rrset_type = 'CNAME';

Get entries with a specific value

select
  rrset_name,
from
  gandi_livedns_record
where
  domain = 'example.net'
  and rrset_values ? 'test';

Schema for gandi_livedns_record

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
domain	text	=	Domain name.
rrset_href	text		URL for the record.
rrset_name	text		Name of the record.
rrset_ttl	text		The time in seconds that DNS resolvers should cache this record.
rrset_type	text		One of: A, AAAA, ALIAS, CAA, CDS, CNAME, DNAME, DS, KEY, LOC, MX, NAPTR, NS, OPENPGPKEY, PTR, RP, SPF, SRV, SSHFP, TLSA, TXT, WKS.
rrset_values	jsonb		A list of values for this record.