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_problem_note

Obtain information about Notes attached to Problems in the FreshService instance.

You MUST specify a problem_id in the WHERE or JOIN clause.

Examples

List all notes for a specific problem

select
  *
from
  freshservice_problem_note
where
  problem_id = 12345;

List all notes of all problems

select
  p.id,
  p.description_text,
  p.priority_desc,
  n.id as note_id,
  n.body_text as note
from
  freshservice_problem p
  left join freshservice_problem_note n on p.id = n.problem_id;

Schema for freshservice_problem_note

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
body	text		The body of the note in HTML format.
body_text	text		The body of the note in plain text format.
created_at	timestamp with time zone		Timestamp at which the note was created.
id	bigint		ID of the problem note.
notify_emails	jsonb		Array of addresses to which notifications are sent.
problem_id	bigint	=	ID of the problem this note belongs to.
updated_at	timestamp with time zone		Timestamp at which the note was last updated.
user_id	bigint		User ID of the user who created the note.