turbot/imap

GitHub
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

List all mailboxs

select
*
from
imap_mailbox

Get a specific mailbox

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

Mailboxes by message count

select
name,
messages
from
imap_mailbox
order by
messages desc

Mailboxes with unseen messages

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

Get all mailboxes with the Important attribute

select
*
from
imap_mailbox
where
attributes ? '\Important'

.inspect imap_mailbox

Mailboxes in IMAP.

NameTypeDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
attributesjsonbAttributes set on the mailbox.
delimitertextThe server's path separator.
flagsjsonbThe mailbox flags.
messagesbigintThe number of messages in this mailbox.
nametextName of the mailbox, e.g. 'INBOX', '[Gmail]/Drafts'.
permanent_flagsjsonbThe mailbox permanent flags.
read_onlybooleanTrue if the mailbox is open in read-only mode.
recentbigintThe number of messages not seen since the last time the mailbox was opened.
unseenbigintThe number of unread messages.