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_software
Obtain information on Software stored in the FreshService instance.
Examples
List all software registered in FreshService
select *from freshservice_software;
List software managed by a specific agent
select s.id, s.name, s.category, s.user_count, concat(a.first_name, ' ', a.last_name) as agent_namefrom freshservice_software s inner join freshservice_agent a on s.managed_by_id = a.idwhere a.email = 'test@example.com';
Schema for freshservice_software
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
application_type | text | Type of the software. | |
category | text | Category of the software. | |
created_at | timestamp with time zone | Timestamp when software record is created. | |
description | text | Description of the software. | |
id | bigint | = | ID of the software. |
installation_count | bigint | Number of devices the software is installed on. | |
managed_by_id | bigint | User ID of the agent managing the software. | |
name | text | Name of the software. | |
notes | text | Notes about the software. | |
publisher_id | bigint | ID of the publisher. | |
status | text | Status of the software. | |
updated_at | timestamp with time zone | Timestamp when the software record was last updated. | |
user_count | bigint | Number of users using this software. |