theapsgroup/freshservice
steampipe plugin install theapsgroup/freshservice

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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
created_attimestamp with time zoneTimestamp when the role was created.
defaultbooleanTrue if it is a default role.
descriptiontextDescription of the role.
idbigint=ID of the role.
nametextName of the role.
updated_attimestamp with time zoneTimestamp when the role was last updated.