Table: zendesk_organization - Query Zendesk Organizations using SQL

Zendesk Organizations is a feature within Zendesk that allows you to group users into organizations based on various criteria like domain names, email addresses, or custom rules. It provides a way to manage and track tickets from users who are part of the same organization. Zendesk Organizations helps you organize users for better support and reporting.

Table Usage Guide

The zendesk_organization table provides insights into Zendesk Organizations. As a Support Manager, explore organization-specific details through this table, including associated users, tickets, and other relevant details. Utilize it to uncover information about organizations, such as those with a large number of tickets, the users associated with each organization, and the overall structure of your support environment.

Examples

Basic organization info

Explore the basic details of your organization to gain insights into its identity. This can assist in understanding the organization's structure and operations.

select
  id,
  name
from
  zendesk_organization;

select
  id,
  name
from
  zendesk_organization;

Explore discrepancies in your organization's sharing settings by identifying instances where ticket and comment sharing settings do not align. This can be beneficial in maintaining consistency and ensuring proper data sharing protocols within your organization.

select
  name,
  shared_comments,
  shared_tickets
from
  zendesk_organization
where
  shared_comments != shared_tickets;

select
  name,
  shared_comments,
  shared_tickets
from
  zendesk_organization
where
  shared_comments != shared_tickets;

Get ticket counts by organization

Explore which organizations have the highest number of tickets to identify potential areas of customer service issues or high engagement. This allows for targeted problem-solving or resource allocation.

select
  o.name,
  count(t.id)
from
  zendesk_organization as o,
  zendesk_ticket as t
where
  o.id = t.organization_id
group by
  o.name
order by
  count desc;

select
  o.name,
  count(t.id)
from
  zendesk_organization as o,
  zendesk_ticket as t
where
  o.id = t.organization_id
group by
  o.name
order by
  count(t.id) desc;

Find all users for an organization

Explore which users are part of a specific organization to understand team composition and manage access rights. This is beneficial in a scenario where you need to audit user access or update organization-wide communication.

select
  u.name,
  u.email
from
  zendesk_user as u,
  zendesk_organization as o
where
  u.organization_id = o.id
  and o.name ilike 'ACME';

select
  u.name,
  u.email
from
  zendesk_user as u,
  zendesk_organization as o
where
  u.organization_id = o.id
  and lower(o.name) like lower('ACME');

Schema for zendesk_organization

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
created_at	timestamp with time zone		The time the organization was created
domain_names	jsonb		An array of domain names associated with this organization
group_id	bigint		New tickets from users in this organization are automatically put in this group
id	bigint	=	Automatically assigned when the organization is created
name	text		A unique name for the organization
organization_fields	jsonb		Custom fields for this organization
shared_comments	boolean		End users in this organization are able to see each other's comments on tickets
shared_tickets	boolean		End users in this organization are able to see each other's tickets
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.
tags	jsonb		The tags of the organization
updated_at	timestamp with time zone		The time of the last update of the organization
url	text		The API url of this organization

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_organization