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_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 rolefrom 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_idorder 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. |