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

Obtain information about Assets from the FreshService instance.

Examples

List all assets

select
  *
from
  freshservice_asset;

Obtain a specific asset, it's type and assignee

select
  a.display_id,
  a.name,
  a.assigned_on,
  t.name as asset_type,
  t.description,
  u.first_name,
  u.last_name,
  u.email
from
  freshservice.freshservice_asset a
  inner join freshservice_asset_type t on a.asset_type_id = t.id
  inner join freshservice_requester u on a.user_id = u.id
where
  a.id = 27001020436;

Schema for freshservice_asset

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
agent_id	bigint		ID of the associated agent.
asset_tag	text		Asset tag of the asset.
asset_type_id	bigint		ID of the asset type.
assigned_on	timestamp with time zone		Timestamp when the asset was assigned.
author_type	text		Indicates whether the asset was created by a user or discovery tools - (Probe, Agent).
created_at	timestamp with time zone		Timestamp when the asset was created.
department_id	bigint		ID of the associated department.
description	text		Description of the asset.
display_id	bigint	=	Display ID of the asset.
group_id	bigint		ID of the associated agent group.
id	bigint		ID of the asset.
impact	text		Impact of the asset.
location_id	bigint		ID of the assets associated location.
name	text		Name of the asset.
updated_at	timestamp with time zone		Timestamp when the asset was updated.
usage_type	text		Usage type of the asset - (Loaner, Permanent).
user_id	bigint		ID of the user using/associated to the asset.