steampipe plugin install imapsteampipe plugin install imap

Table: imap_mailbox

Query information about mailboxes accessible on the IMAP server (e.g. INBOX, [Gmail]/Sent Mail).

Examples

select
  *
from
  imap_mailbox

select
  *
from
  imap_mailbox
where
  name = '[Gmail]/Starred'

select
  name,
  messages
from
  imap_mailbox
order by
  messages desc

select
  name,
  unseen
from
  imap_mailbox
where
  unseen > 0
order by
  unseen desc

select
  *
from
  imap_mailbox
where
  attributes ? '\Important'

Mailboxes in IMAP.

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
attributes	jsonb	Attributes set on the mailbox.
delimiter	text	The server's path separator.
flags	jsonb	The mailbox flags.
messages	bigint	The number of messages in this mailbox.
name	text	Name of the mailbox, e.g. 'INBOX', '[Gmail]/Drafts'.
permanent_flags	jsonb	The mailbox permanent flags.
read_only	boolean	True if the mailbox is open in read-only mode.
recent	bigint	The number of messages not seen since the last time the mailbox was opened.
unseen	bigint	The number of unread messages.