Table: zendesk_group - Query Zendesk Groups using SQL

Zendesk Groups are a feature within Zendesk Support that allow you to organize your agents into different groups. This helps in managing and routing tickets effectively. Groups can be based on the agent's expertise, the team they belong to, the type of issue, or any other criteria.

Table Usage Guide

The zendesk_group table provides insights into Groups within Zendesk Support. As a support manager or team lead, explore group-specific details through this table, including group members, associated tickets, and related information. Utilize it to manage workload distribution, ensure efficient ticket routing, and improve overall support operations.

Examples

Basic group info

Explore the different groups available within your Zendesk account to better manage customer interactions and support workflows. This can be particularly useful for organizing your support team and streamlining communication.

select
  id,
  name
from
  zendesk_group;

select
  id,
  name
from
  zendesk_group;

Schema for zendesk_group

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
created_at	timestamp with time zone		The time the group was created
deleted	boolean		True if the group has been deleted
id	bigint	=	Unique identifier for the group
name	text		Name of the group
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
subdomain	text	=, !=, ~~, ~~, !~~, !~~	The organization subdomain name of the Zendesk instance.
updated_at	timestamp with time zone		The time of the last update of the group
url	text		API url of the group

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)" -- zendesk

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

steampipe_export_zendesk --config '<your_config>' zendesk_group