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, namefrom zendesk_group;
select id, namefrom zendesk_group;
Schema for zendesk_group
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
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 | |
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