theapsgroup/freshservice
steampipe plugin install theapsgroup/freshservice

Table: freshservice_problem

Obtain information on Problems raised in the FreshService instance.

Examples

List all problems

select
*
from
freshservice_problem;

List problems that're not known issues

select
*
from
freshservice_problem
where
known_error = false;

List problems assigned to a specific agent

select
id,
description
from
freshservice_problem
where
agent_id = 2578963125;

Schema for freshservice_problem

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
agent_idbigintUser ID of the agent to whom the problem is assigned.
associated_changebigintID of the change associated with the problem.
categorytextCategory of the problem.
created_attimestamp with time zoneTimestamp at which the problem was created.
department_idbigintID of the department initiating the problem.
descriptiontextHTML content of the problem.
description_texttextPlain text content of the problem.
due_bytimestamp with time zoneTimestamp at which problem is due to be resolved by.
group_idbigintID of the agent group to which the problem has been assigned.
idbigint=ID of the problem.
impactbigintImpact of the problem.
impact_desctextDescription of the problems impact.
item_categorytextItem category of the problem.
known_errorbooleanSet to true if the problem is a known issue/problem/error.
prioritybigintPriority of the problem.
priority_desctextDescription of the problems priority
problem_causetextCause of the problem.
problem_impacttextImpact of the problem (textual description).
problem_symptomtextSymptom(s) of the problem.
requester_idbigintUser ID of the requester.
statusbigintStatus of the problem.
status_desctextDescription of the problems status.
sub_categorytextSub-category of the problem.
subjecttextSubject of the problem.
updated_attimestamp with time zoneTimestamp at which the problem was last updated.