steampipe plugin install theapsgroup/freshservicesteampipe plugin install theapsgroup/freshservice

Table: freshservice_software_user

Obtain information Users assigned to Software.

Examples

select
  *
from
  freshservice_software_user
where
  software_id = 20585369;

select
  *
from
  freshservice_software_user
where
  software_id = 20585369
  and id = 1008564;

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
allocated_date	timestamp with time zone		Timestamp when the license was allocated.
created_at	timestamp with time zone		Timestamp when the installation was created.
first_used	timestamp with time zone		Timestamp when the software was first used by the user.
id	bigint	=	ID of the software-user combination.
last_used	timestamp with time zone		Timestamp when the software was last used by the user.
license_id	bigint		Display ID of the allocated software license contract.
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 software.