steampipe plugin install theapsgroup/freshservicesteampipe plugin install theapsgroup/freshservice

Table: freshservice_ticket_task

Allows for obtaining information on tasks associated to a specific Ticket.

You MUST specify a ticket_id in the WHERE or JOIN clause.

Examples

select
  *
from
  freshservice_ticket_task
where
  ticket_id = 2010101010;

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
agent_id	bigint		ID of the agent to whom the task is assigned.
closed_at	timestamp with time zone		Timestamp when the task was closed.
created_at	timestamp with time zone		Timestamp when the task was created.
description	text		Description of the task.
due_date	timestamp with time zone		Timestamp that denotes the due date of the task.
group_id	bigint		ID of the group to which the task is assigned.
id	bigint		ID of the task.
notify_before	bigint		Time in seconds before which notification is sent prior to due date.
status	bigint		Status of the task.
status_desc	text		Description of the task status.
ticket_id	bigint	=	ID of the ticket the task belongs to.
title	text		Title of the task.
updated_at	timestamp with time zone		Timestamp when the task was updated.