theapsgroup/freshservice
steampipe plugin install theapsgroup/freshservice

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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
agent_idbigintID of the associated agent.
asset_tagtextAsset tag of the asset.
asset_type_idbigintID of the asset type.
assigned_ontimestamp with time zoneTimestamp when the asset was assigned.
author_typetextIndicates whether the asset was created by a user or discovery tools - (Probe, Agent).
created_attimestamp with time zoneTimestamp when the asset was created.
department_idbigintID of the associated department.
descriptiontextDescription of the asset.
display_idbigint=Display ID of the asset.
group_idbigintID of the associated agent group.
idbigintID of the asset.
impacttextImpact of the asset.
location_idbigintID of the assets associated location.
nametextName of the asset.
updated_attimestamp with time zoneTimestamp when the asset was updated.
usage_typetextUsage type of the asset - (Loaner, Permanent).
user_idbigintID of the user using/associated to the asset.