theapsgroup/freshservice
steampipe plugin install theapsgroup/freshservice

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_location
where
id = 27004001;

Schema for freshservice_location

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
citytextName of the city.
countrytextName of the country.
created_attimestamp with time zoneTimestamp when the location was created.
idbigint=ID of the location.
line1textAddress line 1.
line2textAddress line 2.
nametextName of the location.
parent_location_idbigintID of the parent location.
primary_contact_idbigintUser ID of the primary contact.
statetextName of the state.
updated_attimestamp with time zoneTimestamp when the location was last updated.
zipcodetextZip/Postal code of the location.