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_contract
Allows for obtaining information about contracts associated to an Asset.
You MUST specify an asset_display_id
in the WHERE
or JOIN
clause.
Examples
List all contracts associated to a specific asset
select *from freshservice_asset_contractwhere asset_display_id = 1234;
Obtain only active contracts for a specific asset
select *from freshservice_asset_contractwhere asset_display_id = 1234 and contract_status = 'Active';
Schema for freshservice_asset_contract
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. |
contract_id | text | Unique reference/contract number. | |
contract_name | text | Subject/title of the contract. | |
contract_status | text | Status of the contract. | |
contract_type | text | Type of the contract. (Example: Lease, Maintenance) | |
id | bigint | ID of the contract specific to your account. |