Table: duo_account_summary - Query Duo Security Account Summaries using SQL

Duo Security is a cloud-based access security provider protecting the world's fastest-growing and largest companies and thousands of organizations worldwide. It provides a comprehensive security solution that verifies the identity of users and the health of their devices before granting them access to applications. Duo Security offers a range of authentication methods and flexible policies to ensure secure access to all applications.

Table Usage Guide

The duo_account_summary table provides insights into Duo Security Account Summaries. As a security administrator, explore account-specific details through this table, including account name, account ID, and API hostname. Utilize it to uncover information about your Duo Security accounts, such as the identification of accounts for specific applications and the verification of API hostnames.

Examples

Get account summary

select
  *
from
  duo_account_summary;

select
  *
from
  duo_account_summary;

Schema for duo_account_summary

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
admin_count	bigint		Current number of admins in the account.
integration_count	bigint		Current number of integrations in the account.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
telephony_credits_remaining	bigint		Current total number of telephony credits available in the account. This is the sum of all types of telephony credits.
user_count	bigint		Current number of users in the account.
user_pending_deletion_count	bigint		Current number of users pending deletion from the account (seen in the Admin Panel's Trash view).

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- duo

You can pass the configuration to the command with the --config argument:

steampipe_export_duo --config '<your_config>' duo_account_summary