steampipe plugin install theapsgroup/freshservicesteampipe plugin install theapsgroup/freshservice

Table: freshservice_sla_policy

Obtain information on Service Level Agreement Policies defined in the FreshService instance.

Examples

select
  *
from
  freshservice_sla_policy;

select
  id,
  name,
  active,
  deleted,
  category,
  sub_category,
  item_category
from
  freshservice_sla_policy
where
  is_default = true;

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
active	boolean	Set to true if the policy is activated.
category	text	Category the policy is applicable to.
created_at	timestamp with time zone	Timestamp when the policy was created.
deleted	boolean	Set to true if the policy is deleted.
department_id	jsonb	Array of department IDs the policy is applicable to.
description	text	Short description of the policy.
group_id	jsonb	Array of group IDs the policy is applicable to.
id	bigint	ID of the policy.
is_default	boolean	Set to true if the policy is the default.
item_category	text	Item Category the policy is applicable to.
name	text	Name of the policy.
position	bigint	Position (ranking) of the policy among other policies.
service_categories	jsonb	Array of service category IDs the policy is applicable to.
service_items	jsonb	Array of service item IDs the policy is applicable to.
sla_targets	jsonb	Array of policy targets.
source	jsonb	Array of source IDs the policy is applicable to.
sub_category	text	Sub-Category the policy is applicable to.
ticket_type	jsonb	Array of ticket types the policy is applicable to.
updated_at	timestamp with time zone	Timestamp when the policy was last updated.