steampipe plugin install theapsgroup/freshservicesteampipe plugin install theapsgroup/freshservice

freshservice_agent freshservice_agent_role freshservice_announcement freshservice_asset freshservice_asset_component freshservice_asset_contract freshservice_asset_type freshservice_business_hour freshservice_change freshservice_change_note freshservice_contract freshservice_contract_type freshservice_department freshservice_location freshservice_problem freshservice_problem_note freshservice_problem_task freshservice_problem_timeentry freshservice_product freshservice_purchase_order freshservice_release freshservice_release_note freshservice_release_task freshservice_release_timeentry freshservice_requester freshservice_service freshservice_sla_policy freshservice_software freshservice_software_installation freshservice_software_user freshservice_solution_article freshservice_solution_category freshservice_solution_folder freshservice_ticket freshservice_ticket_conversation freshservice_ticket_task freshservice_ticket_timeentry freshservice_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_name
from
  freshservice_software s
  inner join freshservice_agent a on s.managed_by_id = a.id
where
  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.