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_role

Obtain information about Agent Roles from the FreshService instance.

Examples

List all agent roles

select
  *
from
  freshservice_agent_role;

List all agents with their roles

select
  a.email,
  r.name as role
from
  freshservice.freshservice_agent a
  cross join jsonb_to_recordset(a.roles) as ar(role_id bigint)
  inner join freshservice.freshservice_agent_role r on r.id :: bigint = ar.role_id
order by
  email;

Schema for freshservice_agent_role

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
created_at	timestamp with time zone		Timestamp when the role was created.
default	boolean		True if it is a default role.
description	text		Description of the role.
id	bigint	=	ID of the role.
name	text		Name of the role.
updated_at	timestamp with time zone		Timestamp when the role was last updated.