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
0
votes
0 answers

how to calculate packet drop % for AWS NAT Gateway in New Relic

I'm trying to calculate the Packets Drop % in the new relic for AWS NAT Gateway I'm able found out that Drop Percentage = (Number of Dropped Packets / Number of Transmitted Packets) * 100 i have the attribute for Packet Drop but i'm not able to…
Rishab Shalla
  • 1
0
votes
1 answer

NRQL New Relic Query How to get a count for occurrences in the same log

Given I have a log like the following, is it possible to retrieve the count of occurences in the same log? my.failures:"[{\"id\": \"one\", \"file\": \"myfile1\"}, {\"id\": \"one\", \"file\": \"myfile2\"}, {\"id\": \"two\", \"file\":…
Harts
  • 4,023
  • 9
  • 54
  • 93
0
votes
0 answers

New Relic nri flex integration to alert password expiry of users like tomcat fuse wpms oracle

I have 1 automation to do through new relic monitoring tool i hato make a custom warning alert integration in new relic to check the password expiry of users like tomcat, fuse, oracle, wpms Till now I achieved that through creating a yaml file for a…
Somesh Sharma
  • 1
  • 1
0
votes
0 answers

NewRelic - Alerting threshold going beyond the defined scope

I'm attempting to create an alert on NewRelic for the first time, but I'm not sure I'm understanding how it functions correctly. In the above image, I've selected "Creation Alert Condition" from the Throughput section of the dashboard and it brings…
Calvin Nisson
  • 11
  • 3
0
votes
1 answer

New Relic - NRQL query to group error.class with a count not working

I am trying to run the following NRQL query: FROM TransactionError SELECT count(*) AS 'ErrorCount', error.class, error.message SINCE 24 hours ago FACET error.class But I am getting the following error : Unknown expression error.class (at line 0…
AxleWack
  • 1,801
  • 1
  • 19
  • 51
0
votes
0 answers

Finding total duration between two events

I am trying to get total duration spent between two events by a set of unique user id's. The two events are startCount and endCount. I know how to fetch the user id's who has completed the event Count session completed like below. But how do I find…
user264953
  • 1,837
  • 8
  • 37
  • 63
0
votes
1 answer

NRQL IF statement to select wanted value

I'm trying to get one result from query in NRQL, when external is bigger than 0 then it should return average(external), if not average(thirdparty). If that was SQL, it would be easy. SELECT average(externalDuration) FROM Transaction... What I…
Konrad Marciniak
  • 1
0
votes
1 answer

NRQL: How can I determine if a pod has been missing from a Kubernetes node for a specified amount of time?

Issue: Writing a query to check all Kubernetes nodes to make sure coredns is running, and if not - has it been for more than 30 minutes since it was? - if so, send an alert. The alert part will be secondary to my initial question and doesn't have to…
NayefMusa
  • 11
  • 6
0
votes
1 answer

Write a alert condition for Application monitoring using NewRelic Agent?

I recently installed the New Relic agent on Windows server 2012. The goal I am trying to achieve is to create the alert condition for IIS application pools running in windows server 2012 using New Relic Agent when the application is stopped need to…
Azure Cloud Enthusiast
  • 85
  • 1
  • 11
0
votes
1 answer

Using IN Operator in Nested Select in NRQL (New Relic)

I have two different custom events. prod:order:OrderStatusUpdated prod:tenant:StoreStatusChanged I would like to know the storeNumber that exists in prod:tenant:StoreStatusChanged event, but does not exist in prod:order:OrderStatusUpdated. The…
Jorge Freitas
  • 790
  • 10
  • 18
0
votes
1 answer

Minus NRQL average(diskFreeBytes) in New Relic

I would like to show a graph in New Relic with diskspace where below 1 TB is considered 0 in the graph. And values above are shown without the Terabyte, so 1200 GB shows in graph as only 200. NRQL that works SELECT average(diskFreeBytes)/pow(2,30)…
Thomas Koelle
  • 3,416
  • 2
  • 23
  • 44
0
votes
2 answers

New Relic not dispatching NRQL alert condition for process when errors are triggered

I'm creating a monitoring for a process using New Relic. The process itself is an AWS Lambda that finishes running in around 15 seconds. Any time this process fails, I want to an alert to be triggered and an email to be sent to me per the policy…
Adam Freymiller
  • 1,929
  • 7
  • 27
  • 49
0
votes
1 answer

Alerts based on Java Heap Usage

We currently utilize New Relic as the APM. However, the problem that I came across with New Relic (may be not necessarily New Relic specific) is that, I cannot create an Alert, let's say when there is steady rise in the used heap space even after a…
Siddhant
  • 571
  • 1
  • 8
  • 32
0
votes
0 answers

How to alert on slack about a HTTP request if it takes more time to complete than specific time

I have a http request. https://server:port//get_somthing?x=10. Assume that it is expected to respond within 1 second. I notice this in newrelic that, sometimes it takes 1.5, 2 seconds. I would like to look into the logs and investigate whenever it…
user9920500
  • 606
  • 7
  • 21
0
votes
1 answer

New Relic - average page load time for ajax response body count?

I'm pretty new to New Relic & Insights and am having trouble coming up with the right query to benchmark my page. Here's an example situation: lets say I have a page that manages my library of books. Users can log in and go to a page that shows the…
ianking
  • 75
  • 6
1
2
3