theapsgroup/freshservice
steampipe plugin install theapsgroup/freshservice

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_hour
where
id = 123456789;

Schema for freshservice_business_hour

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
created_attimestamp with time zoneTimestamp when the business hours configuration were created.
descriptiontextDescription about the business hours configuration.
idbigint=ID of the business hours configuration.
is_defaultbooleanTrue if the business hours configuration is the default present in Freshservice.
list_of_holidaysjsonbContains the list of dates and names of holidays for the year.
nametextName of the business hours configuration.
service_desk_hoursjsonbContains the time at which the workday begins and ends for the seven days of the week.
time_zonetextTime zone that the business hours configuration functions in.
updated_attimestamp with time zoneTimestamp when the business hours configuration were last updated.