Table: newrelic_apm_application_deployment - Query New Relic APM Application Deployments using SQL

New Relic Application Performance Monitoring (APM) is a tool that provides real-time monitoring and alerting of application performance and health. It offers end-to-end transaction tracing, allowing you to isolate and solve application issues before they affect customers. With New Relic APM, you can track deployments, identify errors, and drill down into detailed performance data.

Table Usage Guide

The newrelic_apm_application_deployment table provides insights into application deployments within New Relic APM. As a DevOps engineer, explore deployment-specific details through this table, including revision, timestamp, user, and change log. Utilize it to track the history of application deployments, identify changes, and understand the impact of each deployment on application performance.

Important Notes

You must specify the app_id in the where clause to query this table.

Examples

List all deployments

Explore all deployments related to a specific application, including their individual details and timestamps. This aids in tracking the history of deployments and identifying any changes made by users over time.

select
  id,
  description,
  revision,
  changelog,
  user,
  timestamp,
  app_id
from
  newrelic_apm_application_deployment
where
  app_id = 45;

select
  id,
  description,
  revision,
  changelog,
  user,
  timestamp,
  app_id
from
  newrelic_apm_application_deployment
where
  app_id = 45;

List all deployments for a specific application by name

This example allows you to identify all deployments associated with a particular application, helping you track changes and updates made over time. This can be useful in managing application versions and understanding the history of application modifications.

select
  id,
  description,
  revision,
  changelog,
  user,
  timestamp,
  app_id
from
  newrelic_apm_application_deployment
where
  app_id in (
    select
      id
    from
      newrelic_apm_application
    where
      name = 'my-app'
  );

select
  id,
  description,
  revision,
  changelog,
  user,
  timestamp,
  app_id
from
  newrelic_apm_application_deployment
where
  app_id in (
    select
      id
    from
      newrelic_apm_application
    where
      name = 'my-app'
  );

Schema for newrelic_apm_application_deployment

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
app_id	bigint	=	The identifier of the application the deployment is linked to.
changelog	text		The changelog entry associated with the deployment.
description	text		The description of the deployment.
id	bigint		Unique identifier of the deployment.
profile_id	text	=, !=, ~~, ~~, !~~, !~~	Unique identifier of the current user.
revision	text		The revision of the deployment.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
timestamp	timestamp with time zone		The timestamp of when the deployment was deployed.
user	text		The user associated with the deployment.

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_apm_application_deployment