turbot/duo

GitHub
steampipe plugin install duosteampipe plugin install duo

Table: duo_token

Tokens in the Duo account.

Examples

List all tokens

select
serial,
token_id,
type
from
duo_token
order by
serial

Tokens and their users

select
t.serial,
u ->> 'username' as username
from
duo_token as t,
jsonb_array_elements(t.users) as u
order by
serial,
username

Tokens by platform

select
type,
count(*)
from
duo_token
group by
type
order by
type

.inspect duo_token

Tokens in the Duo account.

NameTypeDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
serialtextThe serial number of the hardware token; used to uniquely identify the hardware token when paired with type.
token_idtextThe token's ID.
totp_steptextValue is null for all supported token types.
typetextSpecify a type and serial number to look up a single hardware token. One of: h6 (HOTP-6 hardware token), h8 (HOTP-8 hardware token), yk (YubiKey AES hardware token), d1 (Duo-D100 hardware token).
usersjsonbA list of end users associated with this hardware token.