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_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.emailfrom 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.idwhere 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. |