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_product
Obtain information on Products in the FreshService instance.
Examples
Get a specific Product by id
select *from freshservice_productwhere id = 27000001;
List all Products
select *from freshservice_product;
List all Products for visible Asset Types
select p.id, p.name, p.status, p.manufacturerfrom freshservice_product p inner join freshservice_asset_type at on p.asset_type_id = at.idwhere 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. |