steampipe plugin install theapsgroup/freshservicesteampipe plugin install theapsgroup/freshservice

freshservice_agent freshservice_agent_role freshservice_announcement freshservice_asset freshservice_asset_component freshservice_asset_contract freshservice_asset_type freshservice_business_hour freshservice_change freshservice_change_note freshservice_contract freshservice_contract_type freshservice_department freshservice_location freshservice_problem freshservice_problem_note freshservice_problem_task freshservice_problem_timeentry freshservice_product freshservice_purchase_order freshservice_release freshservice_release_note freshservice_release_task freshservice_release_timeentry freshservice_requester freshservice_service freshservice_sla_policy freshservice_software freshservice_software_installation freshservice_software_user freshservice_solution_article freshservice_solution_category freshservice_solution_folder freshservice_ticket freshservice_ticket_conversation freshservice_ticket_task freshservice_ticket_timeentry freshservice_vendor

Table: freshservice_ticket

Obtain information about Tickets in the FreshService instance.

Examples

List all tickets

select
  *
from
  freshservice_ticket;

List tickets raised by a specific email address

select
  *
from
  freshservice_ticket
where
  email = 'some@email.here';

List tickets that are `Open` and `Urgent`

select
  t.id,
  t.subject,
  t.name as requester,
  t.status_desc as status,
  t.priority_desc as priority,
  t.category,
  t.sub_category,
  t.item_category,
  t.due_by,
  concat(a.first_name, ' ', a.last_name) as agent
from
  freshservice_ticket t
  left outer join freshservice_agent a on t.responder_id = a.id
where
  status = 2
  and priority = 4;

Schema for freshservice_ticket

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
attachments	jsonb		Ticket attachments.
category	text		Ticket category.
created_at	timestamp with time zone		Timestamp when the ticket was created.
deleted	boolean		Set to true if the ticket has been deleted/trashed.
department_id	bigint		ID of the department to which this ticket belongs.
description	text		HTML content of the ticket.
description_text	text		Plain text content of the ticket.
due_by	timestamp with time zone		Timestamp that denotes when the ticket is due to be resolved.
email	text	=	Email address of the requester.
fr_due_by	timestamp with time zone		Timestamp that denotes when the first response is due.
fr_escalated	boolean		Set to true if the ticket has been escalated as a result of the first response time being breached.
group_id	bigint		ID of the group to which the ticket has been assigned.
id	bigint	=	ID of the ticket.
impact	bigint		Ticket impact.
is_escalated	boolean		Set to true if the ticket has been escalated for any reason.
item_category	text		Ticket item category.
name	text		Name of the requester.
phone	text		Phone number of the requester.
priority	bigint		Priority of the ticket.
priority_desc	text		Description of the ticket priority
requester_id	bigint	=	User ID of the requester.
responder_id	bigint		ID of the agent to whom the ticket has been assigned.
source	bigint		The channel through which the ticket was created.
spam	boolean		Set to true if the ticket has been marked as spam.
status	bigint		Status of the ticket.
status_desc	text		Description of the ticket status.
sub_category	text		Ticket sub category.
subject	text		Subject of the ticket.
tags	jsonb		Array of tags that have been associated with the ticket.
type	text	=	Helps categorize the ticket according to the different kinds of issues your support team deals with.
updated_at	timestamp with time zone		Timestamp when the ticket was last updated.
urgency	bigint		Ticket urgency.

Table: freshservice_ticket

Examples

List all tickets

List tickets raised by a specific email address

List tickets that are Open and Urgent

Schema for freshservice_ticket

List tickets that are `Open` and `Urgent`