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_installation
Obtain information about Installations of Software registered in the FreshService instance.
Examples
List all installations for a specific software
select *from freshservice_software_installationwhere software_id = 465465131;
List software installations associated with a specific user (requester)
select *from freshservice_software_installation fsi inner join freshservice_software fs on fsi.software_id = fs.idwhere fsi.user_id = 27000123;
Schema for freshservice_software_installation
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
created_at | timestamp with time zone | Timestamp when the installation was created. | |
department_id | bigint | ID of the department the device belongs to. | |
id | bigint | ID of the software installation. | |
installation_date | timestamp with time zone | Timestamp when the software was installed. | |
installation_machine_id | bigint | Display ID of the asset on which the software is installed. | |
installation_path | text | Path where the software is installed. | |
software_id | bigint | = | ID of the software this installation belong to. |
updated_at | timestamp with time zone | Timestamp when the installation was last updated. | |
user_id | bigint | ID of the user using the device. | |
version | text | Version of the installed software. |