theapsgroup/freshservice
steampipe plugin install theapsgroup/freshservice

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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
application_typetextType of the software.
categorytextCategory of the software.
created_attimestamp with time zoneTimestamp when software record is created.
descriptiontextDescription of the software.
idbigint=ID of the software.
installation_countbigintNumber of devices the software is installed on.
managed_by_idbigintUser ID of the agent managing the software.
nametextName of the software.
notestextNotes about the software.
publisher_idbigintID of the publisher.
statustextStatus of the software.
updated_attimestamp with time zoneTimestamp when the software record was last updated.
user_countbigintNumber of users using this software.