steampipe plugin install theapsgroup/freshservicesteampipe plugin install theapsgroup/freshservice

freshservice_agent freshservice_agent_role freshservice_announcement freshservice_asset freshservice_asset_component freshservice_asset_contract freshservice_asset_type freshservice_business_hour freshservice_change freshservice_change_note freshservice_contract freshservice_contract_type freshservice_department freshservice_location freshservice_problem freshservice_problem_note freshservice_problem_task freshservice_problem_timeentry freshservice_product freshservice_purchase_order freshservice_release freshservice_release_note freshservice_release_task freshservice_release_timeentry freshservice_requester freshservice_service freshservice_sla_policy freshservice_software freshservice_software_installation freshservice_software_user freshservice_solution_article freshservice_solution_category freshservice_solution_folder freshservice_ticket freshservice_ticket_conversation freshservice_ticket_task freshservice_ticket_timeentry freshservice_vendor

Table: freshservice_change

Obtain information about Changes in the FreshService instance.

List all changes

select
  *
from
  freshservice_change;

Obtain changes assigned to a specific agent

select
  c.id as change_id,
  c.description_text as change,
  c.status_desc as status,
  a.email as agent
from
  freshservice_change c
  inner join freshservice_agent a on c.agent_id = a.id
where
  a.id = 12345;

Schema for freshservice_change

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
agent_id	bigint		ID of the agent to whom the change is assigned.
approval_status	bigint		Approval status of the change.
category	text		Category of the change.
created_at	timestamp with time zone		Timestamp at which the change was created.
department_id	bigint		ID of the department initiating the change.
description	text		HTML content of the change.
description_text	text		Plain text content of the change.
group_id	bigint		ID of the agent group to which the change is assigned.
id	bigint	=	ID of the change.
impact	bigint		Impact of the change.
impact_desc	text		Description of the change impact.
item_category	text		Item of the change.
planned_end_date	timestamp with time zone		Timestamp at which change is ending.
planned_start_date	timestamp with time zone		Timestamp at which change is starting.
priority	bigint		Priority of the change.
priority_desc	text		Description of the change priority
requester_id	bigint	=	User ID of the initiator/requester of the change.
risk	bigint		Risk of the change.
risk_desc	text		Description of the change risk.
status	bigint		Status of the change.
status_desc	text		Description of the change status.
sub_category	text		Sub-category of the change.
subject	text		Subject of the change.
type	bigint		Type of the change.
type_desc	text		Description of the change type.
updated_at	timestamp with time zone		Timestamp at which the change was last updated.