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_contract
Obtain information about Contracts from the FreshService instance.
Examples
List all contracts
select *from freshservice_contract;
List contracts which did not yet start
select c.id, c.name, c.description, c.contract_number, v.name as vendor, c.start_datefrom freshservice_contract c inner join freshservice_vendor v on c.vendor_id = v.idwhere c.start_date > NOW() :: timestamp;
Schema for freshservice_contract
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
approver_id | bigint | ID of the agent who needs to approve the contract. | |
auto_renew | boolean | True if the contract renews automatically. | |
contract_number | text | Unique reference number for the contract. | |
contract_type_id | bigint | ID of the contract type. | |
cost | text | Cost of the contract. | |
created_at | timestamp with time zone | Timestamp at which the contract was created. | |
delegatee_id | bigint | ID of the agent whom the contract approval is delegated to | |
description | text | Description of the contract. | |
end_date | timestamp with time zone | End date of the contract. | |
expiry_notified | boolean | True if the contract expiration notification has been sent. | |
id | bigint | = | ID of the contract. |
name | text | Name of the contract. | |
notify_before | bigint | Number of days before contract expiry date when the expiry notifications need to be sent. | |
notify_expiry | boolean | True if the expiration notifications are configured for the contract. | |
notify_to | jsonb | Array of email address whom should be notified of contract expiry. | |
requester_id | bigint | ID of user whom created/renewed the contract. | |
start_date | timestamp with time zone | Start date of the contract. | |
status | text | Status of the contract. | |
updated_at | timestamp with time zone | Timestamp at which the contract was last updated. | |
vendor_id | bigint | ID of the vendor. | |
visible_to_id | bigint | ID of agent group in FreshService to control visibility of the contract. |