freshservice_agentfreshservice_agent_rolefreshservice_announcementfreshservice_assetfreshservice_asset_componentfreshservice_asset_contractfreshservice_asset_typefreshservice_business_hourfreshservice_changefreshservice_change_notefreshservice_contractfreshservice_contract_typefreshservice_departmentfreshservice_locationfreshservice_problemfreshservice_problem_notefreshservice_problem_taskfreshservice_problem_timeentryfreshservice_productfreshservice_purchase_orderfreshservice_releasefreshservice_release_notefreshservice_release_taskfreshservice_release_timeentryfreshservice_requesterfreshservice_servicefreshservice_sla_policyfreshservice_softwarefreshservice_software_installationfreshservice_software_userfreshservice_solution_articlefreshservice_solution_categoryfreshservice_solution_folderfreshservice_ticketfreshservice_ticket_conversationfreshservice_ticket_taskfreshservice_ticket_timeentryfreshservice_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_agentwhere 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_namefrom 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 | |
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. |