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_location
Obtain information on locations registered in the FreshService Instance.
Examples
List all locations
select *from freshservice_location;
Get a specific location by id
select *from freshservice_locationwhere id = 27004001;
Schema for freshservice_location
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
city | text | Name of the city. | |
country | text | Name of the country. | |
created_at | timestamp with time zone | Timestamp when the location was created. | |
id | bigint | = | ID of the location. |
line1 | text | Address line 1. | |
line2 | text | Address line 2. | |
name | text | Name of the location. | |
parent_location_id | bigint | ID of the parent location. | |
primary_contact_id | bigint | User ID of the primary contact. | |
state | text | Name of the state. | |
updated_at | timestamp with time zone | Timestamp when the location was last updated. | |
zipcode | text | Zip/Postal code of the location. |