steampipe plugin install theapsgroup/freshservicesteampipe plugin install theapsgroup/freshservice

Table: freshservice_problem_timeentry

Obtain time entries for a specific Problem in the FreshService instance.

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

Examples

select
  *
from
  freshservice_problem_timeentry
where
  problem_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 as true if the time entry is billable.
created_at	timestamp with time zone		Timestamp when the 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.
problem_id	bigint	=	ID of the problem 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 date_time at which the timer is started again.
task_id	bigint		ID of the task associated with the time entry.
time_spent	text		The total amount of time spent by the timer in hh::mm format.
timer_running	boolean		Set to true if timer is currently running.
updated_at	timestamp with time zone		Timestamp when the time entry was last updated.