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_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_namefrom freshservice_requester r left join freshservice_requester m on r.reporting_manager_id = m.id;
List inactive users
select *from freshservice_requesterwhere 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. | |
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. |