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_asset_component

Allows for obtaining information about component parts of Assets from within the FreshService instance.

You MUST specify an asset_display_id in the WHERE or JOIN clause.

Examples

List all components for a specific asset

select
  *
from
  freshervice_asset_component
where
  asset_display_id = 1234;

List all components of all Assets

select
  a.id,
  a.display_id,
  a.name,
  a.asset_tag,
  c.id as component_id,
  c.component_type,
  c.component_data
from
  freshservice_asset a
  left join freshservice_asset_component c on a.display_id = c.asset_display_id;

Schema for freshservice_asset_component

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
asset_display_id	bigint	=	Display ID of the parent asset
component_data	jsonb		Details of the component.
component_type	text		Type of the component. (Example: Processor, Memory)
created_at	timestamp with time zone		Timestamp when the component was created.
id	bigint		ID of the component.
updated_at	timestamp with time zone		Timestamp when the component was updated.