steampipe plugin install theapsgroup/freshservicesteampipe plugin install theapsgroup/freshservice

Table: freshservice_ticket_timeentry

Allows for obtaining all the time entries against a specific Ticket.

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

Examples

select
  *
from
  freshservice_ticket_timeentry
where
  ticket_id = 2010101010;

select
  *
from
  freshservice_ticket_timeentry
where
  ticket_id = 2010101010
  and billable = false;

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 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.
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 at which the timer is started again.
task_id	bigint		ID of the task assigned to the time entry.
ticket_id	bigint	=	ID of the ticket the time entry belongs to.
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 was last updated.