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_business_hour
Obtain the Business Hours configurations from the FreshService instance.
Examples
List all Business Hours configurations
select *from freshservice_business_hour;
Obtain a specific Business Hour configuration by ID
select *from freshservice_business_hourwhere id = 123456789;
Schema for freshservice_business_hour
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
created_at | timestamp with time zone | Timestamp when the business hours configuration were created. | |
description | text | Description about the business hours configuration. | |
id | bigint | = | ID of the business hours configuration. |
is_default | boolean | True if the business hours configuration is the default present in Freshservice. | |
list_of_holidays | jsonb | Contains the list of dates and names of holidays for the year. | |
name | text | Name of the business hours configuration. | |
service_desk_hours | jsonb | Contains the time at which the workday begins and ends for the seven days of the week. | |
time_zone | text | Time zone that the business hours configuration functions in. | |
updated_at | timestamp with time zone | Timestamp when the business hours configuration were last updated. |