steampipe plugin install theapsgroup/freshservicesteampipe plugin install theapsgroup/freshservice

Table: freshservice_problem

Obtain information on Problems raised in the FreshService instance.

Examples

select
  *
from
  freshservice_problem;

select
  *
from
  freshservice_problem
where
  known_error = false;

select
  id,
  description
from
  freshservice_problem
where
  agent_id = 2578963125;

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 problem is assigned.
associated_change	bigint		ID of the change associated with the problem.
category	text		Category of the problem.
created_at	timestamp with time zone		Timestamp at which the problem was created.
department_id	bigint		ID of the department initiating the problem.
description	text		HTML content of the problem.
description_text	text		Plain text content of the problem.
due_by	timestamp with time zone		Timestamp at which problem is due to be resolved by.
group_id	bigint		ID of the agent group to which the problem has been assigned.
id	bigint	=	ID of the problem.
impact	bigint		Impact of the problem.
impact_desc	text		Description of the problems impact.
item_category	text		Item category of the problem.
known_error	boolean		Set to true if the problem is a known issue/problem/error.
priority	bigint		Priority of the problem.
priority_desc	text		Description of the problems priority
problem_cause	text		Cause of the problem.
problem_impact	text		Impact of the problem (textual description).
problem_symptom	text		Symptom(s) of the problem.
requester_id	bigint		User ID of the requester.
status	bigint		Status of the problem.
status_desc	text		Description of the problems status.
sub_category	text		Sub-category of the problem.
subject	text		Subject of the problem.
updated_at	timestamp with time zone		Timestamp at which the problem was last updated.