theapsgroup/freshservice
steampipe plugin install theapsgroup/freshservice

Table: freshservice_solution_folder

Obtain Solution Folders from the FreshService instance.

Examples

List all solution folders

select
*
from
freshservice_solution_folder;

Get a specific solution folder by id

select
*
from
freshservice_solution_folder
where
id = 200964200;

Schema for freshservice_solution_folder

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
category_idbigintID of the category under which the solution folder is listed.
created_attimestamp with time zoneTimestamp when the solution folder was created.
default_categorybooleanSet to true if the solution folder is the default one.
department_idsjsonbArray of IDs of the departments to which this solution folder is visible.
descriptiontextDescription about the solution folder.
group_idsjsonbArray of IDs of the agent groups to which this solution folder is visible.
idbigint=ID of the solution folder.
manage_by_group_idsjsonbArray of IDs of groups which manage this solution folder.
nametextName of the solution folder.
positionbigintThe rank of the solution folder in the folder listing.
requester_group_idsjsonbArray of IDs of requester groups to which this solution folder is visible.
updated_attimestamp with time zoneTimestamp when the solution folder was last updated.
visibilitybigintAccessibility of this solution folder.