freshservice_agentfreshservice_agent_rolefreshservice_announcementfreshservice_assetfreshservice_asset_componentfreshservice_asset_contractfreshservice_asset_typefreshservice_business_hourfreshservice_changefreshservice_change_notefreshservice_contractfreshservice_contract_typefreshservice_departmentfreshservice_locationfreshservice_problemfreshservice_problem_notefreshservice_problem_taskfreshservice_problem_timeentryfreshservice_productfreshservice_purchase_orderfreshservice_releasefreshservice_release_notefreshservice_release_taskfreshservice_release_timeentryfreshservice_requesterfreshservice_servicefreshservice_sla_policyfreshservice_softwarefreshservice_software_installationfreshservice_software_userfreshservice_solution_articlefreshservice_solution_categoryfreshservice_solution_folderfreshservice_ticketfreshservice_ticket_conversationfreshservice_ticket_taskfreshservice_ticket_timeentryfreshservice_vendor
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_problemwhere known_error = false;
List problems assigned to a specific agent
select id, descriptionfrom freshservice_problemwhere agent_id = 2578963125;
Schema for freshservice_problem
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. |