theapsgroup/freshservice
steampipe plugin install theapsgroup/freshservice

Table: freshservice_requester

Obtain information about Requesters (users) from your FreshService instance.

Examples

List all requesters

select
*
from
freshservice_requester;

List users and reporting manager

select
r.id,
concat(r.first_name, ' ', r.last_name) as requester_name,
r.email,
r.active,
concat(m.first_name, ' ', m.last_name) as manager_name
from
freshservice_requester r
left join freshservice_requester m on r.reporting_manager_id = m.id;

List inactive users

select
*
from
freshservice_requester
where
active = false;

Schema for freshservice_requester

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
activebooleanSet to true if the requester is active (enabled)
addresstextAddress of the requester.
background_informationtextBackground information of the requester.
created_attimestamp with time zoneTimestamp when the requester was created.
department_idsjsonbArray of IDs of the departments associated with the requester.
emailtext=Primary email address of the requester.
first_nametextFirst name of the requester.
has_logged_inbooleanSet to true if the requester has logged in to Freshservice at least once.
idbigint=User ID of the requester.
is_agentbooleanSet to true if the requester is also an agent.
job_titletextJob title of the requester.
languagetextLanguage used by the requester. The default language is “en” (English).
last_nametextLast name of the requester.
location_idbigintID of the location associated with the requester.
mobile_phone_numbertextMobile phone number of the requester.
reporting_manager_idbigintUser ID of the requesters reporting manager.
secondary_emailsjsonbArray of secondary emails associated with the requester.
time_formattextChosen time format (12h or 24h) of the requester.
time_zonetextTime zone associated to the requester.
updated_attimestamp with time zoneTimestamp when the requester was last updated.
work_phone_numbertextWork phone number of the requester.