Table: duo_token
Tokens in the Duo account.
Examples
List all tokens
select serial, token_id, typefrom duo_tokenorder by serial
Tokens and their users
select t.serial, u ->> 'username' as usernamefrom duo_token as t, jsonb_array_elements(t.users) as uorder by serial, username
Tokens by platform
select type, count(*)from duo_tokengroup by typeorder by type
.inspect duo_token
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. |