theapsgroup/freshservice
steampipe plugin install theapsgroup/freshservice

Table: freshservice_release_task

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

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

Examples

List all tasks on a specific Release

select
*
from
freshservice_release_task
where
release_id = 2011111111;

Schema for freshservice_release_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.
release_idbigint=ID of the release the task belongs to.
statusbigintStatus of the task.
status_desctextDescription of the task status.
titletextTitle of the task.
updated_attimestamp with time zoneTimestamp when the task was updated.