Plugins

turbot/duo

GitHub
Overview
11Tables
Versions
GitHub
steampipe plugin install duosteampipe plugin install duo
duo_account_settingsduo_account_summaryduo_admin_log_recordduo_administrative_unitduo_administratorduo_auth_log_recordduo_groupduo_integrationduo_phoneduo_tokenduo_user
On This Page
Examples
.inspect
Get Involved
Discuss on Slack

Table: duo_phone

Phones in the Duo account.

Examples

List all phones

select
  number,
  extension,
  type,
  platform,
  model,
  phone_id
from
  duo_phone
order by
  number,
  extension

Phones and their users

select
  p.number,
  p.extension,
  u ->> 'username' as username
from
  duo_phone as p,
  jsonb_array_elements(p.users) as u
order by
  number,
  extension,
  username

Phones that are not yet activated

select
  number,
  extension,
  phone_id
from
  duo_phone
where
  not activated
order by
  number,
  extension

Phones by platform

select
  platform,
  count(*)
from
  duo_phone
group by
  platform
order by
  platform

Users of phones that have been tampered with

select
  u ->> 'username' as username,
  p.number,
  p.extension
from
  duo_phone as p,
  jsonb_array_elements(p.users) as u
where
  p.tampered = 'Tampered'
order by
  username,
  number,
  extension

Users of phones without encryption

select
  u ->> 'username' as username,
  p.number,
  p.extension,
  p.encrypted
from
  duo_phone as p,
  jsonb_array_elements(p.users) as u
where
  p.encrypted is null
  or p.encrypted != 'Encrypted'
order by
  username,
  number,
  extension

.inspect duo_phone

Phones in the Duo account.

NameTypeDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
activatedbooleanHas this phone been activated for Duo Mobile yet?
capabilitiesjsonbList of strings, each a factor that can be used with the device: push, phone, sms, mobile_otp.
encryptedtextThe encryption status of an Android or iOS device file system. One of: Encrypted, Unencrypted, or Unknown. Blank for other platforms.
extensiontextAn extension, if necessary.
fingerprinttextWhether an Android or iOS phone is configured for biometric verification. One of: Configured, Disabled, or Unknown. Blank for other platforms.
modeltextThe phone's model.
nametextFree-form label for the phone.
numbertextThe phone number. A phone with a smartphone platform but no number is a tablet.
phone_idtextThe phone's ID.
platformtextThe 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'.
postdelaybigintThe time (in seconds) to wait after the extension is dialed and before the speaking the prompt.
predelaybigintThe time (in seconds) to wait after the number picks up and before dialing the extension.
screenlocktextWhether screen lock is enabled on an Android or iOS phone. One of: Locked, Unlocked, or Unknown. Blank for other platforms.
sms_passcodes_sentbooleanHave SMS passcodes been sent to this phone?
tamperedtextWhether an iOS or Android device is jailbroken or rooted. One of: Not Tampered, Tampered, or Unknown. Blank for other platforms.
typetextThe type of phone. One of: unknown, mobile, or landline.
usersjsonbList of users to which this phone belongs.