theapsgroup/freshservice
steampipe 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

List all tasks on a specific Ticket

select
*
from
freshservice_ticket_task
where
ticket_id = 2010101010;

Schema for freshservice_ticket_task

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
agent_idbigintID of the agent to whom the task is assigned.
closed_attimestamp with time zoneTimestamp when the task was closed.
created_attimestamp with time zoneTimestamp when the task was created.
descriptiontextDescription of the task.
due_datetimestamp with time zoneTimestamp that denotes the due date of the task.
group_idbigintID of the group to which the task is assigned.
idbigintID of the task.
notify_beforebigintTime in seconds before which notification is sent prior to due date.
statusbigintStatus of the task.
status_desctextDescription of the task status.
ticket_idbigint=ID of the ticket the task belongs to.
titletextTitle of the task.
updated_attimestamp with time zoneTimestamp when the task was updated.