Table: duo_phone
Phones in the Duo account.
Examples
List all phones
select number, extension, type, platform, model, phone_idfrom duo_phoneorder by number, extension
Phones and their users
select p.number, p.extension, u ->> 'username' as usernamefrom duo_phone as p, jsonb_array_elements(p.users) as uorder by number, extension, username
Phones that are not yet activated
select number, extension, phone_idfrom duo_phonewhere not activatedorder by number, extension
Phones by platform
select platform, count(*)from duo_phonegroup by platformorder by platform
Users of phones that have been tampered with
select u ->> 'username' as username, p.number, p.extensionfrom duo_phone as p, jsonb_array_elements(p.users) as uwhere p.tampered = 'Tampered'order by username, number, extension
Users of phones without encryption
select u ->> 'username' as username, p.number, p.extension, p.encryptedfrom duo_phone as p, jsonb_array_elements(p.users) as uwhere p.encrypted is null or p.encrypted != 'Encrypted'order by username, number, extension
.inspect duo_phone
Phones in the Duo account.
Name | Type | Description |
---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. |
activated | boolean | Has this phone been activated for Duo Mobile yet? |
capabilities | jsonb | List of strings, each a factor that can be used with the device: push, phone, sms, mobile_otp. |
encrypted | text | The encryption status of an Android or iOS device file system. One of: Encrypted, Unencrypted, or Unknown. Blank for other platforms. |
extension | text | An extension, if necessary. |
fingerprint | text | Whether an Android or iOS phone is configured for biometric verification. One of: Configured, Disabled, or Unknown. Blank for other platforms. |
model | text | The phone's model. |
name | text | Free-form label for the phone. |
number | text | The phone number. A phone with a smartphone platform but no number is a tablet. |
phone_id | text | The phone's ID. |
platform | text | The phone platform. One of: 'unknown', 'google android', 'apple ios', 'windows phone 7', 'rim blackberry', 'java j2me', 'palm webos', 'symbian os', 'windows mobile', or 'generic smartphone'. |
postdelay | bigint | The time (in seconds) to wait after the extension is dialed and before the speaking the prompt. |
predelay | bigint | The time (in seconds) to wait after the number picks up and before dialing the extension. |
screenlock | text | Whether screen lock is enabled on an Android or iOS phone. One of: Locked, Unlocked, or Unknown. Blank for other platforms. |
sms_passcodes_sent | boolean | Have SMS passcodes been sent to this phone? |
tampered | text | Whether an iOS or Android device is jailbroken or rooted. One of: Not Tampered, Tampered, or Unknown. Blank for other platforms. |
type | text | The type of phone. One of: unknown, mobile, or landline. |
users | jsonb | List of users to which this phone belongs. |