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_announcement

Obtain information about Announcements from the FreshService instance.

Examples

List all announcements

select
  *
from
  freshservice_announcement;

List announcements scheduled for the future

select
  *
from
  freshservice_announcement
where
  state = 'scheduled';

List announcements created by a specific agent

select
  a.title,
  a.body,
  concat(ag.first_name, ' ', ag.last_name) as agent
from
  freshservice_announcement a
  left join freshservice_agent ag on a.created_by = ag.id
where
  ag.email = 'example@agent.com';

Schema for freshservice_announcement

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
additional_emails	jsonb		Array of additional email addresses to which the announcement needs to be sent.
body	text		Body of the announcement.
body_html	text		Body of the announcement in HTML format.
created_at	timestamp with time zone		Timestamp when the announcement was created.
created_by	bigint		ID of the agent that created this announcement.
departments	jsonb		Array of Department IDs that can view this announcement.
groups	jsonb		Array of Group IDs that can view this announcement.
id	bigint	=	ID of the announcement.
is_read	boolean		True if the logged-in-user has read the announcement.
send_email	boolean		True if the announcement needs to be sent via email.
state	text	=	State of the announcement - (active, archived, scheduled).
title	text		Title of the announcement.
updated_at	timestamp with time zone		Timestamp when the announcement was last updated.
visibility	text		Visibility of the announcement - (everyone, agents_only, agents_and_groups).
visible_from	timestamp with time zone		Timestamp at which the announcement becomes active.
visible_to	timestamp with time zone		Timestamp until the announcement is active.