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_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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
active	boolean		Set to true if the requester is active (enabled)
address	text		Address of the requester.
background_information	text		Background information of the requester.
created_at	timestamp with time zone		Timestamp when the requester was created.
department_ids	jsonb		Array of IDs of the departments associated with the requester.
email	text	=	Primary email address of the requester.
first_name	text		First name of the requester.
has_logged_in	boolean		Set to true if the requester has logged in to Freshservice at least once.
id	bigint	=	User ID of the requester.
is_agent	boolean		Set to true if the requester is also an agent.
job_title	text		Job title of the requester.
language	text		Language used by the requester. The default language is “en” (English).
last_name	text		Last name of the requester.
location_id	bigint		ID of the location associated with the requester.
mobile_phone_number	text		Mobile phone number of the requester.
reporting_manager_id	bigint		User ID of the requesters reporting manager.
secondary_emails	jsonb		Array of secondary emails associated with the requester.
time_format	text		Chosen time format (12h or 24h) of the requester.
time_zone	text		Time zone associated to the requester.
updated_at	timestamp with time zone		Timestamp when the requester was last updated.
work_phone_number	text		Work phone number of the requester.