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_mailbox

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

Examples

List mailboxes of a domain

select
  address
from
  gandi_mailbox
where
  domain = 'example.net';

List maiboxes across all your domains

select
  m.domain,
  m.address
from
  gandi_mailbox m
  join gandi_domain d on d.fqdn = m.domain;

List maiboxes that are 90% of their quota

select
  m.domain,
  m.address,
  m.quota_used
from
  gandi_mailbox m
  join gandi_domain d on d.fqdn = m.domain
where
  case
    when m.mailbox_type = 'premium' then (100 * m.quota_used) / 50000000
    else (100 * m.quota_used) / 3000000
  end > 90;

Schema for gandi_mailbox

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
address	text		Full email address.
antispam	boolean		Antispam is enabled.
autorenew_duration	bigint		Duration for autorenew.
autorenew_duration_type	text		Type of duration ('m' for month).
autorenew_enabled	boolean		Specify if autorenew is enabled on this mailbox.
domain	text	=	Domain name.
expires_at	timestamp with time zone		Expiry date of the mailbox.
href	text		Link to mailbox details.
id	text	=	Unique id of the mailbox.
login	text		Mailbox login.
mailbox_type	text		The type of mailbox, one of: 'standard', 'premium', 'free'.
quota_used	bigint		Quota used.