Stack Overflow
Stack Overflow

Questions tagged [nrql]

The New Relic Query Language (NRQL) is query language similar to SQL that you use to make calls against the New Relic Insights Events database.

35 questions
2
votes
0 answers

How to represent a comma-separated list in a NewRelic pie chart?

From a Java app, I would like to send some custom parameters to our NewRelic agent (7.9.0), like this (seems that only booleans, integers and strings are accepted): NewRelic.addCustomParameter("myList",…
Jocelyn
  • 277
  • 4
  • 21
1
vote
1 answer

Response time graph in New Relic with percentiles

I have a requirement to reproduce an existing performance report as a New Relic graph. The existing report produced by our custom APM solution shows a graph with the average response time of all web requests in a given time period. Also plotted on…
Stephen Williams
  • 13
  • 4
1
vote
1 answer

Trying to retrieve list of browser widths in New Relic but can't ORDER BY in NRQL

I'm trying to get a list of all browser widths used and the number of times, in order of size. So: 1920 - 12,356 1440 - 19,453 1280 - 10,847 1024 - 4,124 or something like that. It's important to list them in order of width, not usage. I'm using…
wagster
  • 498
  • 4
  • 15
1
vote
1 answer

How to find number of days between 2 dates in different format in NRQL?

I have to find difference between 2 different date formats in new relic using NRQL. The below query returns SELECT latest(expiresAt),latest(dateOf(timestamp)) FROM abc 2023-01-27,April 13, 2022 as output. Now i have to find number of days between…
rajkumar11
  • 75
  • 5
1
vote
1 answer

Find Average response time of all urls present in Synthetic monitor of New Relic

I am having a Synthetic monitor for monitoring. I would like to write a query to find the average response time of all URLs present in my Synthetic monitor and create a dashboard. I can find the individual response time of the URL and create the…
Azure Cloud Enthusiast
  • 85
  • 1
  • 11
1
vote
2 answers

Show full number on New Relic count column

When I search for SELECT count(*) FROM requests WHERE foo = 'bar' FACET dateOf(eventtime) SINCE 3 days ago in New Relic, it gives me the following table: DATE OF EVENTTIME COUNT December 9, 2021 1.76 M However, I want to know what…
sidney
  • 1,241
  • 15
  • 32
1
vote
1 answer

What's the most frequent error? NRQL Query

I'm trying to figure out how to use New Relic Query Builder and I having trouble with this query: What's the most frequent error? I tried : SELECT level FROM Log WHERE level='error' AND rate(level)
Michaela Lewis
  • 11
  • 1
1
vote
3 answers

NRQL percentage of one subset over another

I have a great big eventing table with lots of different types of events, and I'm working on a New Relic graph to show the percentage of one kind of event to another kind of event. (NOT percentage over the total row count in the table). So in this…
Diane Kaplan
  • 1,626
  • 3
  • 24
  • 34
1
vote
2 answers

Response time in new relic query language

What is the NRQL query to generate the segmented response time time series like the one which is shown below? I tried various queries but was not able to get the desired results?
CodeCore
  • 63
  • 2
  • 10
0
votes
1 answer

How to get unique AppVersion on unique Uuid in New Relic using NRQL?

I can get the usage on each version using NRQL SELECT count(*) FROM MobileSession since 1 day ago WHERE (appName = 'app-name') FACET (appVersion) limit MAX but these are not unique Uuid, i.e. the same person/uuid having multiple session would be…
Elye
  • 53,639
  • 54
  • 212
  • 474
0
votes
0 answers

Is there a NewRelic API to consume service levels (SLIs, SLOs)?

We have setup some SLIs and SLOs for some backend services using NewRelic Service levels. We want to consume those SLOs through an API to interrupt our Jenkins CI in case of SLO violations. I have gone through NewRelic documentation but could only…
anand
  • 301
  • 1
  • 3
  • 10
0
votes
0 answers

Get Percentage Difference as a separate column when using COMPARE WITH clause in Newrelic NRQL

I need to be able to see pages that have increased page load duration in the current week than the previous week. I have used the following NRQL : FROM PageView select count(*), average(duration) facet pageUrl since 1 week ago COMPARE WITH 1 week…
PrathapB
  • 382
  • 1
  • 4
  • 15
0
votes
1 answer

NRQL using the FACET count value as a filter

I am hoping to FACET values together and then get a count of those values that have > 2 results. I have this part. SELECT count(*) as 'requestCount' FROM Transaction WHERE FACET SomeId This returns ID1 - 3 ID2 - 1 ID3 - 5 ID4 - 1 ID5 - 7 But I…
Matt
  • 487
  • 1
  • 6
  • 16
0
votes
1 answer

Query data for unique combinations of facets without COUNT or SUM?

I am currently trying to formulate a better query than what I currently have at the moment. For analysis reasons, I want to see the different combinations of facets a certain record has. Currently I use SELECT COUNT(myRecord)FROM Metric FACET foo,…
ADC2000
  • 63
  • 7
0
votes
0 answers

Getting "Parsing failed" Error for all NRQL queries while posting via HttpURLConnection in Java program

I have written a Java Program to connect to NewRelic Graphql API end point https://api.newrelic.com/graphql and successfully able to connect. However getting parsing error for the NRQL query. Query is {"query": "SELECT average(duration) FROM…
Pavani Sandhya
  • 1
1
2 3