Table: duo_group - Query Duo Security Groups using SQL

Duo Security Groups are collections of users within Duo's two-factor authentication system, allowing for more efficient management of user access and permissions. Groups can be used to assign different policies or applications to different sets of users. This is a critical aspect of managing security and access control in an organization.

Table Usage Guide

The duo_group table provides insights into Duo Security Groups within Duo's two-factor authentication system. As a security or IT professional, explore group-specific details through this table, including the group's ID, name, description, and status. Utilize it to manage and monitor user access and permissions, enabling better security and control within your organization.

Examples

List all groups

select
  name,
  group_id,
  status,
  description
from
  duo_group
order by
  name;

select
  name,
  group_id,
  status,
  description
from
  duo_group
order by
  name;

Group statistics by status

select
  status,
  count(*)
from
  duo_group
group by
  status
order by
  status;

select
  status,
  count(*)
from
  duo_group
group by
  status
order by
  status;

List disabled groups

select
  name
from
  duo_group
where
  status = 'disabled'
order by
  name;

select
  name
from
  duo_group
where
  status = 'disabled'
order by
  name;

Schema for duo_group

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
description	text		The group's description.
group_id	text	=	The group's ID.
name	text		The group's name. If managed by directory sync, then the name returned here also indicates the source directory.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text		The group's authentication status. May be one of: active, bypass, disabled.

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_group