steampipe plugin install zendesk

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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
created_attimestamp with time zoneThe time the group was created
deletedbooleanTrue if the group has been deleted
idbigint=Unique identifier for the group
nametextName of the group
updated_attimestamp with time zoneThe time of the last update of the group
urltextAPI 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