icon/x Created with Sketch.

Splunk Cookie Policy

We use our own and third-party cookies to provide you with a great online experience. We also use these cookies to improve our products and services, support our marketing campaigns, and advertise to you on our website and other websites. Some cookies may continue to collect information after you have left our website. Learn more (including how to update your settings) here.
Accept Cookie Policy

Accept License Agreements

This app is provided by a third party and your right to use the app is in accordance with the license provided by that third-party licensor. Splunk is not responsible for any third-party apps and does not provide any warranty or support. If you have any questions, complaints or claims with respect to this app, please contact the licensor directly.

Thank You

Downloading New Relic NRQL Command for Splunk
SHA256 checksum (new-relic-nrql-command-for-splunk_101.tgz) d4d3e9ccd9063289e1a43fb667f46fba175a907761a7b001c3400d17ac3f1632
To install your download
For instructions specific to your download, click the Details tab after closing this window.

Flag As Inappropriate

New Relic NRQL Command for Splunk

Admins: Please read about Splunk Enterprise 8.0 and the Python 2.7 end-of-life changes and impact on apps and upgradeshere.
Overview
Details
The New Relic NRQL Command for Splunk app contains the Splunk Generating Command "| nrql" which queries New Relic and generates Splunk reports from the query results returned.

For documentation, please see: https://github.com/dmanojbaba/splunk-command-newrelic-nrql/

The New Relic NRQL Command for Splunk app contains the Splunk Generating Command "| nrql" which queries New Relic and generates Splunk reports from the query results returned.

For documentation, please see: https://github.com/dmanojbaba/splunk-command-newrelic-nrql/

Syntax:

| nrql connection=<string> query=<string> (output=_raw)?

Configuration:

  • Create a New Relic Insights API Query Key
  • Create a local configuration file $SPLUNK_HOME/etc/apps/newrelic_nrql_command_for_splunk/local/nrql_connections.conf
  • Add New Relic Endpoint, Account ID and Insights API Query Key details in nrql_connections.conf
  • nrql_connections.conf.spec:
[<name>]
apiEndpoint = <string>
accountId = <string>
queryKey = <string>
  • nrql_connections.conf.example:
[prod-us-account]
apiEndpoint = insights-api.newrelic.com
accountId = 1111111
queryKey = y0ur_ins1ghts_qu3ry_k3y_h3re

[test-eu-account]
apiEndpoint = insights-api.eu.newrelic.com
accountId = 1234567
queryKey = an0ther_ins1ghts_qu3ry_k3y_h3re

Usage:

  • The nrql command is a generating command and should be used as the first command in the search.
  • The connection argument is the name of a configured New Relic connection in nrql_connections.conf.
  • The query argument is a valid NRQL query.
  • The output=_raw (optional) argument is to output the returned data without any formatting.
  • Note: New Relic Event Types (tables) and Attributes (columns) in an NRQL query are case-sensitive. [e.g.: PageView, JavaScriptError, pageUrl, deviceType, errorMessage, etc.]

Examples:

# Query New Relic 'prod-us-account' and return results

| nrql connection="prod-us-account" query="select * from PageView"


# Query New Relic 'test-eu-account' and return results

| nrql connection="test-eu-account" query="select count(*) as TotalTransactions from Transaction"


# Query New Relic 'prod-us-account' and combine the power of Splunk SPL

| nrql connection="prod-us-account" query="select count(*) from PageView facet deviceType 
    since 1 day ago timeseries 1 hour"
| eval _time=strptime(beginTimeSeconds,"%s")
| xyseries _time, deviceType, count

Release Notes

Version 1.0.1
June 26, 2020

6
Installs
19
Downloads
Share Subscribe LOGIN TO DOWNLOAD

Subscribe Share

AppInspect Tooling

Splunk AppInspect evaluates Splunk apps against a set of Splunk-defined criteria to assess the validity and security of an app package and components.

Are you a developer?

As a Splunkbase app developer, you will have access to all Splunk development resources and receive a 10GB license to build an app that will help solve use cases for customers all over the world. Splunkbase has 1000+ apps and add-ons from Splunk, our partners and our community. Find an app or add-on for most any data source and user need, or simply create your own with help from our developer portal.

Follow Us:
© 2005-2020 Splunk Inc. All rights reserved.
Splunk®, Splunk>®, Listen to Your Data®, The Engine for Machine Data®, Hunk®, Splunk Cloud™, Splunk Light™, SPL™ and Splunk MINT™ are trademarks and registered trademarks of Splunk Inc. in the United States and other countries. All other brand names, product names, or trademarks belong to their respective owners.