Find first Occurrence of Errors with NRQL

I want to find the first occurrence of a transaction Error where in UI we can see only 7 days data. Is there any NRQL query with which we can get this data.

SELECT count(1) FROM TransactionError facet error.class WHERE appName = 'My application Name 'and error.class=‘java.util.MissingResourceException’ since this quarter

With this query we are able to see that error first occurred 3 weeks ago . Can we get the exact date and time from NRQL when my error first occurred.

Try something like:

SELECT earliest(timestamp) FROM TransactionError FACET error.class WHERE appName = 'My application Name 'and error.class=‘java.util.MissingResourceException’ SINCE 52 WEEKS AGO
1 Like

this is the response I get with above query mentioned.
Query I shared is also giving same result

over on the right hand side you can change the chart type - switch it to Table and you should get something better in your results

This works. Great !!
Thankyou

You got it :slight_smile: @palvika.nagpal.contr

1 Like