turbot/newrelic
steampipe plugin install newrelic

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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
idbigintUnique identifier for the account.
nametextName of the account.
profile_idtext=, !=, ~~, ~~*, !~~, !~~*Unique identifier of the current user.
reporting_event_typesjsonbAn array of event types that are currently reporting in the account.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.

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