turbot/zendesk

steampipe plugin install zendesksteampipe plugin install zendesk

Table: zendesk_organization

Just as agents can be segmented into groups in Zendesk Support, your customers (end-users) can be segmented into organizations. You can manually assign customers to an organization or automatically assign them to an organization by their email address domain. Organizations can be used in business rules to route tickets to groups of agents or to send email notifications.

Examples

Basic organization info

select
id,
name
from
zendesk_organization;

Check if ticket and comment sharing settings match

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

Get ticket counts by organization

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;`

Find all users for an organization

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';

.inspect zendesk_organization

Just as agents can be segmented into groups in Zendesk Support, your customers (end-users) can be segmented into organizations. You can manually assign customers to an organization or automatically assign them to an organization by their email address domain. Organizations can be used in business rules to route tickets to groups of agents or to send email notifications.

NameTypeDescription
created_attimestamp without time zoneThe time the organization was created
domain_namesjsonbAn array of domain names associated with this organization
group_idbigintNew tickets from users in this organization are automatically put in this group
idbigintAutomatically assigned when the organization is created
nametextA unique name for the organization
organization_fieldsjsonbCustom fields for this organization
shared_commentsbooleanEnd users in this organization are able to see each other's comments on tickets
shared_ticketsbooleanEnd users in this organization are able to see each other's tickets
tagsjsonbThe tags of the organization
updated_attimestamp without time zoneThe time of the last update of the organization
urltextThe API url of this organization