theapsgroup/freshservice
steampipe plugin install theapsgroup/freshservice

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_contract
where
asset_display_id = 1234;

Obtain only active contracts for a specific asset

select
*
from
freshservice_asset_contract
where
asset_display_id = 1234
and contract_status = 'Active';

Schema for freshservice_asset_contract

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
asset_display_idbigint=Display ID of the parent asset.
contract_idtextUnique reference/contract number.
contract_nametextSubject/title of the contract.
contract_statustextStatus of the contract.
contract_typetextType of the contract. (Example: Lease, Maintenance)
idbigintID of the contract specific to your account.