theapsgroup/freshservice
steampipe 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

List all time entries for a given Ticket

select
*
from
freshservice_ticket_timeentry
where
ticket_id = 2010101010;

List all non-billable time entries for a given Ticket

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

Schema for freshservice_ticket_timeentry

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
agent_idbigintUser ID of the agent to whom this time entry is assigned.
billablebooleanSet to true if the time entry is billable.
created_attimestamp with time zoneTimestamp when the time entry is created.
executed_attimestamp with time zoneTimestamp when the timer is executed.
idbigintID of the time entry.
notetextDescription of the time entry.
start_timetimestamp with time zoneTimestamp 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_idbigintID of the task assigned to the time entry.
ticket_idbigint=ID of the ticket the time entry belongs to.
time_spenttextThe total amount of time spent by the timer in hh::mm format. This field cannot be set if timer_running is true.
timer_runningbooleanSet to true if timer is currently running.
updated_attimestamp with time zoneTimestamp when the time entry was last updated.