Table: newrelic_notification_destination - Query New Relic Notification Destinations using SQL
New Relic Notification Destinations are channels configured in New Relic to receive notifications. These channels can be of different types like email, Slack, PagerDuty, etc. They are a crucial part of New Relic's Alert system, tying together the alert policies and the users who need to be notified.
Table Usage Guide
The newrelic_notification_destination
table provides insights into the notification channels configured in New Relic. As a DevOps engineer, you can explore details about these channels, including their types and configurations, through this table. Utilize it to manage and optimize your alert system by understanding the distribution of notifications across different channels.
Important Notes
- You must specify the
account_id
in thewhere
clause to query this table.
Examples
List all notification destinations for a specific account
Determine the areas in which notifications are being sent for a specific user account. This can be useful to audit and manage where notifications are directed, ensuring the right individuals or teams are alerted.
select id, name, account_id, active, created_at, updated_at, updated_by, auth, is_user_authenticated, properties, status, typefrom newrelic_notification_destinationwhere account_id = 21355;
select id, name, account_id, active, created_at, updated_at, updated_by, auth, is_user_authenticated, properties, status, typefrom newrelic_notification_destinationwhere account_id = 21355;
Schema for newrelic_notification_destination
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
account_id | bigint | = | ID of the account the channel belongs to. |
active | boolean | Indicates if the destination is enabled. | |
auth | text | Authentication type used for the destination. | |
created_at | timestamp with time zone | Timestamp when the destination was created. | |
id | text | ID of the channel. | |
is_user_authenticated | boolean | Indicates if current user is authenticated with the destination. | |
last_sent | timestamp with time zone | Timestamp when last notification was sent to destination. | |
name | text | Name of the destination. | |
properties | jsonb | Array of properties associated with the destination. | |
status | text | Status of the destination. | |
type | text | Type of the destination. | |
updated_at | timestamp with time zone | Timestamp when destination was last updated. | |
updated_by | bigint | The ID of the user which last updated the channel. |
Export
This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.
You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh
script:
/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- newrelic
You can pass the configuration to the command with the --config
argument:
steampipe_export_newrelic --config '<your_config>' newrelic_notification_destination