freshservice_agentfreshservice_agent_rolefreshservice_announcementfreshservice_assetfreshservice_asset_componentfreshservice_asset_contractfreshservice_asset_typefreshservice_business_hourfreshservice_changefreshservice_change_notefreshservice_contractfreshservice_contract_typefreshservice_departmentfreshservice_locationfreshservice_problemfreshservice_problem_notefreshservice_problem_taskfreshservice_problem_timeentryfreshservice_productfreshservice_purchase_orderfreshservice_releasefreshservice_release_notefreshservice_release_taskfreshservice_release_timeentryfreshservice_requesterfreshservice_servicefreshservice_sla_policyfreshservice_softwarefreshservice_software_installationfreshservice_software_userfreshservice_solution_articlefreshservice_solution_categoryfreshservice_solution_folderfreshservice_ticketfreshservice_ticket_conversationfreshservice_ticket_taskfreshservice_ticket_timeentryfreshservice_vendor
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_categoryfrom freshservice_sla_policywhere is_default = true;
Schema for freshservice_sla_policy
Name | Type | Operators | 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. |