Gandi Source PluginLatest: v1.1.8
The CloudQuery Gandi plugin pulls configuration out of Gandi resources and loads it into any supported CloudQuery destination (e.g. PostgreSQL).
In order to fetch information from Gandi,
cloudquery needs to be authenticated. An API key is required for authentication. Get your API key from Gandi's Account Settings Page (opens in a new tab).
select fqdn, dates->>'registry_ends_at' as registry_ends_at, date_trunc('day', (dates->>'registry_ends_at')::timestamp - current_timestamp) as days_left from gandi_domains where ((dates->>'registry_ends_at')::timestamp - interval '90 day') < current_timestamp order by 1;
select fqdn, current, nameservers from gandi_domain_live_dns order by 1;
select fqdn, name, ips from gandi_domain_glue_records order by 1, 2;
select d.fqdn from gandi_livedns_domains d left join gandi_livedns_snapshots s on s.fqdn=d.fqdn and s.automatic where s.fqdn is null;
select count(1) as number_of_snapshots, max(created_at) as last_snapshot_at from gandi_livedns_snapshots where fqdn = 'yourdomain.com';