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_valuesfrom gandi_livedns_recordwhere domain = 'example.net';
List records with a specific name
select rrset_type, rrset_valuesfrom gandi_livedns_recordwhere domain = 'example.net' and rrset_name = 'test';
List CNAME records
select rrset_name, rrset_valuesfrom gandi_livedns_recordwhere domain = 'example.net' and rrset_type = 'CNAME';
Get entries with a specific value
select rrset_name,from gandi_livedns_recordwhere 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. |