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_contract

Obtain information about Contracts from the FreshService instance.

Examples

List all contracts

select
  *
from
  freshservice_contract;

List contracts which did not yet start

select
  c.id,
  c.name,
  c.description,
  c.contract_number,
  v.name as vendor,
  c.start_date
from
  freshservice_contract c
  inner join freshservice_vendor v on c.vendor_id = v.id
where
  c.start_date > NOW() :: timestamp;

Schema for freshservice_contract

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
approver_id	bigint		ID of the agent who needs to approve the contract.
auto_renew	boolean		True if the contract renews automatically.
contract_number	text		Unique reference number for the contract.
contract_type_id	bigint		ID of the contract type.
cost	text		Cost of the contract.
created_at	timestamp with time zone		Timestamp at which the contract was created.
delegatee_id	bigint		ID of the agent whom the contract approval is delegated to
description	text		Description of the contract.
end_date	timestamp with time zone		End date of the contract.
expiry_notified	boolean		True if the contract expiration notification has been sent.
id	bigint	=	ID of the contract.
name	text		Name of the contract.
notify_before	bigint		Number of days before contract expiry date when the expiry notifications need to be sent.
notify_expiry	boolean		True if the expiration notifications are configured for the contract.
notify_to	jsonb		Array of email address whom should be notified of contract expiry.
requester_id	bigint		ID of user whom created/renewed the contract.
start_date	timestamp with time zone		Start date of the contract.
status	text		Status of the contract.
updated_at	timestamp with time zone		Timestamp at which the contract was last updated.
vendor_id	bigint		ID of the vendor.
visible_to_id	bigint		ID of agent group in FreshService to control visibility of the contract.