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_type

Obtain information about Contract Types in the FreshService instance.

Examples

List all contract types

select
  *
from
  freshservice_contract_type;

List all contracts of a specific type

select
  c.id,
  c.name,
  c.description,
  c.contract_number,
  t.name as contract_type,
  c.start_date
from
  freshservice_contract c
  inner join freshservice_contract_type t on c.contract_type_id = t.id
where
  t.id = 20009451249;

Schema for freshservice_contract_type

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
created_at	timestamp with time zone	Timestamp at which the contract type was created.
description	text	Description of the contract type.
id	bigint	ID of the contract type.
is_default	boolean	True if the contract type is a default (or custom) type.
name	text	Name of the contract type.
needs_approval	boolean	True if the contract type needs approval.
updated_at	timestamp with time zone	Timestamp at which the contract type was last updated.