steampipe 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.


List all time entries for a specific Release

release_id = 2011111111;

Schema for freshservice_release_timeentry

_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 this time entry is created.
executed_attimestamp with time zoneTimestamp when the timer is executed.
idbigintID of the time entry.
notetextDescription of the time entry.
release_idbigint=ID of the release the time entry belongs to.
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 when the timer is started again.
task_idbigintID of the task assigned to the time entry.
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 is updated.