Table: duo_token

Tokens in the Duo account.

Examples

select
  serial,
  token_id,
  type
from
  duo_token
order by
  serial

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

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

Tokens in the Duo account.

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
serial	text	The serial number of the hardware token; used to uniquely identify the hardware token when paired with type.
token_id	text	The token's ID.
totp_step	text	Value is null for all supported token types.
type	text	Specify 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).
users	jsonb	A list of end users associated with this hardware token.