Table: newrelic_component - Query New Relic Components using SQL

New Relic is a software analytics company that offers cloud-based software to help website and application owners track the performances of their services. It provides SaaS Application Performance Management and Digital Intelligence products. New Relic's Components are part of its APM product, which monitor and analyze the performance of software applications.

Table Usage Guide

The newrelic_component table provides insights into the components of applications monitored in New Relic. As a DevOps engineer, explore component-specific details through this table, including metrics, attributes, and associated metadata. Utilize it to uncover information about components, such as their performance, usage, and the overall health of the applications they belong to.

Examples

List all components

Explore the health status and metrics summary of all components in your New Relic account to gain insights into their performance and condition. This could be useful in identifying components that require attention or optimization.

select
  id,
  name health_status,
  summary_metrics
from
  newrelic_component;

select
  id,
  name,
  health_status,
  summary_metrics
from
  newrelic_component;

List components for a specific plugin

Explore the components associated with a specific plugin to gain insights into their health status and key metrics. This can be useful in assessing the performance and reliability of the plugin in question.

select
  id,
  name health_status,
  summary_metrics
from
  newrelic_component
where
  plugin_id = 634;

select
  id,
  name,
  health_status,
  summary_metrics
from
  newrelic_component
where
  plugin_id = 634;

Schema for newrelic_component

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
health_status	text		The health status of the component.
id	bigint	=	Unique identifier for the component.
name	text	=	The name of the component.
plugin_id	bigint	=	Only populated if passed in as a query parameter.
profile_id	text	=, !=, ~~, ~~, !~~, !~~	Unique identifier of the current user.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
summary_metrics	jsonb		An array of metric summaries associated with the component.

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_component