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_release

Obtain information about Releases within the FreshService instance.

Examples

List all releases

select
  *
from
  freshservice_release;

List high priority yet not completed releases

select
  r.id,
  r.subject,
  a.email as assignee,
  r.priority_desc,
  r.status_desc,
  r.planned_start_date,
  r.planned_end_date
from
  freshservice_release r
  left join freshservice_agent a on r.agent_id = a.id
where
  r.status < 5
  and r.priority >= 3;

Schema for freshservice_release

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 release is assigned.
associated_assets	jsonb		Array of IDs of Assets associated with the release.
associated_changes	jsonb		Array of IDs of Changes associated with the release.
category	text		Category of the release.
created_at	timestamp with time zone		Timestamp at which the release was created.
department_id	bigint		ID of the department initiating the release.
description	text		HTML content of the release.
group_id	bigint		ID of the agent group to which the release has been assigned.
id	bigint	=	ID of the release.
item_category	text		Item category of the release.
planned_end_date	timestamp with time zone		Timestamp at which release is planned to end.
planned_start_date	timestamp with time zone		Timestamp at which release is planned to start.
priority	bigint		Priority of the release.
priority_desc	text		Description of the release priority.
release_type	bigint		Type of the release.
release_type_desc	bigint		Description of the release type.
status	bigint		Status of the release.
status_desc	text		Description of the release status.
sub_category	text		Sub-category of the release.
subject	text		Subject of the release.
updated_at	timestamp with time zone		Timestamp at which the release was last updated.
work_end_date	timestamp with time zone		Timestamp at which release work ended.
work_start_date	timestamp with time zone		Timestamp at which release work started.