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_solution_article

Obtain information on Solution Articles stored in the FreshService instance.

Examples

List all solution articles

select
  *
from
  freshservice_solution_article;

Get a specific solution article by id

select
  id,
  title,
  status
from
  freshservice_solution_article
where
  id = 269696969;

List all solution articles for a specific solution category

select
  a.id,
  a.title,
  a.status,
  c.name as category,
  a.views,
  a.review_date
from
  freshservice_solution_article a
  inner join freshservice_solution_category c on a.category_id = c.id;

Schema for freshservice_solution_article

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
agent_id	bigint		ID of the user who created the solution article.
approval_status	bigint		Approval status of the solution article.
article_type	bigint		The type of the article (1 permanent, 2 work-around).
category_id	bigint		ID of the category under which the solution article is belongs.
created_at	timestamp with time zone		Timestamp when the solution article was created.
description	text		Description of the solution article.
folder_id	bigint	=	ID of the folder under which the article is listed.
id	bigint	=	ID of the solution article.
keywords	jsonb		Array of keywords that have been associated with the solution article.
position	bigint		The rank of the solution article in the article listing.
review_date	timestamp with time zone		Timestamp when the solution article needs to be reviewed.
status	bigint		Status of the solution article (1 draft, 2 published).
tags	jsonb		Array of tags that have been associated with the solution article.
thumbs_down	bigint		Number of down-votes for the solution article.
thumbs_up	bigint		Number of up-votes for the solution article.
title	text		Title of the solution article.
updated_at	timestamp with time zone		Timestamp when the solution article was last updated.
url	text		External url for the Solution Article.
views	bigint		Total hit count of the page visits for this solution article.