theapsgroup/freshservice
steampipe plugin install theapsgroup/freshservice

Table: freshservice_product

Obtain information on Products in the FreshService instance.

Examples

Get a specific Product by id

select
*
from
freshservice_product
where
id = 27000001;

List all Products

select
*
from
freshservice_product;

List all Products for visible Asset Types

select
p.id,
p.name,
p.status,
p.manufacturer
from
freshservice_product p
inner join freshservice_asset_type at on p.asset_type_id = at.id
where
at.visible = true;

Schema for freshservice_product

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
asset_type_idbigintID of the asset type.
created_attimestamp with time zoneTimestamp when the product was created.
depreciation_type_idbigintID of the depreciation type.
descriptiontextHTML content of the product.
description_texttextDescription of the product in plain text.
idbigint=ID of the product.
manufacturertextManufacturer of the product
mode_of_procurementtextMode of procurement of the product (Buy, Lease, Both).
nametextName of the product.
statustextStatus of the product (In Production, In Pipeline, Retired).
updated_attimestamp with time zoneTimestamp when the product was last updated.