steampipe plugin install theapsgroup/freshservicesteampipe plugin install theapsgroup/freshservice

Table: freshservice_release_timeentry

Allows for obtaining information on time entries associated to a specific Release.

You MUST specify a release_id in the WHERE or JOIN clause.

Examples

select
  *
from
  freshservice_release_timeentry
where
  release_id = 2011111111;

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
agent_id	bigint		User ID of the agent to whom this time entry is assigned.
billable	boolean		Set to true if the time entry is billable.
created_at	timestamp with time zone		Timestamp when this time entry is created.
executed_at	timestamp with time zone		Timestamp when the timer is executed.
id	bigint		ID of the time entry.
note	text		Description of the time entry.
release_id	bigint	=	ID of the release the time entry belongs to.
start_time	timestamp with time zone		Timestamp when the time entry is added. If a timer, which is in stopped state, is started again, this holds timestamp when the timer is started again.
task_id	bigint		ID of the task assigned to the time entry.
time_spent	text		The total amount of time spent by the timer in hh::mm format. This field cannot be set if timer_running is true.
timer_running	boolean		Set to true if timer is currently running.
updated_at	timestamp with time zone		Timestamp when the time entry is updated.