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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
asset_type_id	bigint		ID of the asset type.
created_at	timestamp with time zone		Timestamp when the product was created.
depreciation_type_id	bigint		ID of the depreciation type.
description	text		HTML content of the product.
description_text	text		Description of the product in plain text.
id	bigint	=	ID of the product.
manufacturer	text		Manufacturer of the product
mode_of_procurement	text		Mode of procurement of the product (Buy, Lease, Both).
name	text		Name of the product.
status	text		Status of the product (In Production, In Pipeline, Retired).
updated_at	timestamp with time zone		Timestamp when the product was last updated.