theapsgroup/freshservice
steampipe plugin install theapsgroup/freshservice

Table: freshservice_sla_policy

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

Examples

List all SLA Policies

select
*
from
freshservice_sla_policy;

Get default SLA Policies

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

Schema for freshservice_sla_policy

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
activebooleanSet to true if the policy is activated.
categorytextCategory the policy is applicable to.
created_attimestamp with time zoneTimestamp when the policy was created.
deletedbooleanSet to true if the policy is deleted.
department_idjsonbArray of department IDs the policy is applicable to.
descriptiontextShort description of the policy.
group_idjsonbArray of group IDs the policy is applicable to.
idbigintID of the policy.
is_defaultbooleanSet to true if the policy is the default.
item_categorytextItem Category the policy is applicable to.
nametextName of the policy.
positionbigintPosition (ranking) of the policy among other policies.
service_categoriesjsonbArray of service category IDs the policy is applicable to.
service_itemsjsonbArray of service item IDs the policy is applicable to.
sla_targetsjsonbArray of policy targets.
sourcejsonbArray of source IDs the policy is applicable to.
sub_categorytextSub-Category the policy is applicable to.
ticket_typejsonbArray of ticket types the policy is applicable to.
updated_attimestamp with time zoneTimestamp when the policy was last updated.