steampipe plugin install theapsgroup/freshservice

Table: freshservice_change

Obtain information about Changes in the FreshService instance.

List all changes


Obtain changes assigned to a specific agent

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

Schema for freshservice_change

_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
agent_idbigintID of the agent to whom the change is assigned.
approval_statusbigintApproval status of the change.
categorytextCategory of the change.
created_attimestamp with time zoneTimestamp at which the change was created.
department_idbigintID of the department initiating the change.
descriptiontextHTML content of the change.
description_texttextPlain text content of the change.
group_idbigintID of the agent group to which the change is assigned.
idbigint=ID of the change.
impactbigintImpact of the change.
impact_desctextDescription of the change impact.
item_categorytextItem of the change.
planned_end_datetimestamp with time zoneTimestamp at which change is ending.
planned_start_datetimestamp with time zoneTimestamp at which change is starting.
prioritybigintPriority of the change.
priority_desctextDescription of the change priority
requester_idbigint=User ID of the initiator/requester of the change.
riskbigintRisk of the change.
risk_desctextDescription of the change risk.
statusbigintStatus of the change.
status_desctextDescription of the change status.
sub_categorytextSub-category of the change.
subjecttextSubject of the change.
typebigintType of the change.
type_desctextDescription of the change type.
updated_attimestamp with time zoneTimestamp at which the change was last updated.