steampipe plugin install theapsgroup/freshservicesteampipe plugin install theapsgroup/freshservice

Table: freshservice_problem_task

Obtain tasks based on an associated Problem in the FreshService instance.

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

Examples

select
  *
from
  freshservice_problem_task
where
  problem_id = 2011111111;

select
  *
from
  freshservice_problem_task
where
  problem_id = 2011111111
  and due_date < NOW() :: timestamp;

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
agent_id	bigint		User ID of the agent to whom the task is assigned
closed_at	timestamp with time zone		Timestamp at which the task was closed.
created_at	timestamp with time zone		Timestamp at which 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.
problem_id	bigint	=	ID of the problem the task belongs to.
status	bigint		Status of the task.
status_desc	text		Description of the task status.
title	text		Title of the task.
updated_at	timestamp with time zone		Timestamp at which the task was last updated.