Table: newrelic_account - Query New Relic Accounts using SQL

New Relic is a performance management solution that enables developers to diagnose and fix application performance problems in real time. It provides visibility into the performance and usage of your software applications. New Relic helps you to understand how your applications are performing and where bottlenecks may be occurring.

Table Usage Guide

The newrelic_account table provides insights into accounts within New Relic. As a developer or DevOps engineer, explore account-specific details through this table, including account ID, name, product, and other related details. Utilize it to uncover information about accounts, such as the products associated with each account, the status of those products, and the overall details of each account.

Examples

List all accounts

Explore which New Relic accounts are available and determine the types of reporting events associated with each. This can help with monitoring and understanding the types of alerts and events that are being generated.

select
  id,
  name,
  reporting_event_types
from
  newrelic_account;

select
  id,
  name,
  reporting_event_types
from
  newrelic_account;

Schema for newrelic_account

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
id	bigint	Unique identifier for the account.
name	text	Name of the account.
reporting_event_types	jsonb	An array of event types that are currently reporting in the account.

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_account