steampipe plugin install theapsgroup/freshservicesteampipe plugin install theapsgroup/freshservice

freshservice_agent freshservice_agent_role freshservice_announcement freshservice_asset freshservice_asset_component freshservice_asset_contract freshservice_asset_type freshservice_business_hour freshservice_change freshservice_change_note freshservice_contract freshservice_contract_type freshservice_department freshservice_location freshservice_problem freshservice_problem_note freshservice_problem_task freshservice_problem_timeentry freshservice_product freshservice_purchase_order freshservice_release freshservice_release_note freshservice_release_task freshservice_release_timeentry freshservice_requester freshservice_service freshservice_sla_policy freshservice_software freshservice_software_installation freshservice_software_user freshservice_solution_article freshservice_solution_category freshservice_solution_folder freshservice_ticket freshservice_ticket_conversation freshservice_ticket_task freshservice_ticket_timeentry freshservice_vendor

Table: freshservice_agent

Obtain information about Agents (operators) of the FreshService instance.

Examples

List all agents

select
  *
from
  freshservice_agent;

List agents that have logged in within last 10 days

select
  *
from
  freshservice_agent
where
  last_login_at > now() :: date -10;

List agents and reporting manager name

select
  a.id,
  concat(a.first_name, ' ', a.last_name) as agent_name,
  a.email,
  a.active,
  concat(m.first_name, ' ', m.last_name) as manager_name
from
  freshservice_agent a
  left join freshservice_agent m on a.reporting_manager_id = m.id;

Schema for freshservice_agent

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
active	boolean	=	True if the agent is active (enabled).
address	text		Address of the agent.
background_information	text		Background information of the agent.
created_at	timestamp with time zone		Timestamp when the agent was created.
department_ids	jsonb		Array of Unique IDs of the departments associated with the agent
email	text	=	Email address of the agent.
first_name	text		First name of the agent.
has_logged_in	boolean		Set to true if the agent has logged in to Freshservice at least once, and false otherwise.
id	bigint	=	User ID of the agent.
job_title	text		Job title of the agent.
language	text		Language used by the agent. The default language is “en” (English).
last_active_at	timestamp with time zone		Timestamp of the agent's recent activity.
last_login_at	timestamp with time zone		Timestamp of the agent's last successful login.
last_name	text		Last name of the agent.
location_id	bigint		ID of the location associated with the agent.
member_of	jsonb		Array of group IDs that the agent is a member of.
mobile_phone_number	text		Mobile phone number of the agent.
occasional	boolean		True if the agent is an occasional agent, and false if full-time agent.
reporting_manager_id	bigint		User ID of the agent's reporting manager.
roles	jsonb		Array of roles assigned to the agent, each individual role is a hash that contains the attributes role_id, assignment_scope & groups.
scoreboard_level_id	bigint		ID of the level of the agent in the Arcade. 1 (Beginner), 2 (Intermediate), 3 (Professional), 4 (Expert), 5 (Master), 6 (Guru).
time_format	text		Agents chosen time format (12h or 24h)
time_zone	text		Time zone associated to the agent.
updated_at	timestamp with time zone		Timestamp when the agent was last updated.
work_phone_number	text		Work phone number of the agent.