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_service

Obtain information about Service Items from the Service Catalog on the FreshService instance.

Examples

List all service items

select
  *
from
  freshservice_service;

Get a specific service item by id

select
  name,
  short_description
from
  freshservice_service
where
  id = 27000112233;

Schema for freshservice_service

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
allow_attachments	boolean		Set to true if the requester is allowed to attach a file.
allow_quantity	boolean		Set to true if the requester is allowed request more than 1 quantity.
botified	boolean		Set to true if the service item is 'bot-ready'.
category_id	bigint		ID of the category of the service item.
ci_type_id	bigint		ID of the asset type associated with the product.
cost	text		Cost of the service item.
cost_visibility	boolean		Set to true if cost should be visible to the requester.
create_child	boolean		Set to true if child items can be created as separate service requests.
created_at	timestamp with time zone		Timestamp when the service item was created.
deleted	boolean		Set to true if the service item is deleted.
delivery_time	bigint		Estimated delivery time of the service item (in hours).
delivery_time_visibility	boolean		Set to true if delivery time of the service item should be visible to the requester.
description	text		Description of the service item.
display_id	bigint		ID of the service item specific to your account.
group_visibility	bigint		1 denotes visibility to all requesters. 2 for restricted visibility.
id	bigint	=	ID of the service item.
is_bundle	boolean		Set to true if the service item contains child items.
item_type	bigint		1 indicates a normal item. 2 indicates a loaner item.
name	text		Name of the service item.
product_id	bigint		The ID of the product mapped to the item.
quantity	bigint		The quantity set against the service item.
short_description	text		Short description of the service item.
updated_at	timestamp with time zone		Timestamp when the service item was updated.
visibility	bigint		1 denotes draft and 2 denotes published.