Skip to main content

Queries using NRQL (New Relic Query Language)

Queries take the general form of:

image.png

SELECT function(attribute) FROM Event_Type FACET dimension

  • SELECT defines the portion of the data you want to query, such as an attribute or a function
  • FROM defines the type of data to be queried
  • FACET details how the data will be grouped together

For example, to see the count of errors listed by hostname, you might use:

SELECT count(*) FROM Error_Messages FACET hostname

The SELECT and FROM selectors are required for most queries, the only exception being when you are deleting data using the DELETE keyword. All other operators and keywords are optional and depend on the particular query that is being written.

FUNCTIONs can be grouped into two categories - Aggregator and Non-aggregator

Aggregator functions are used to filter and aggregate numerical data. Example: average

Non-aggregator functions are used for non-numerical data in NRQL such as querying for an account ID or capturing specific attributes. Example: accountID

Common Event Types By Agent:
Agent Name Event Type
Browser PageView
Application Performance Management Transaction
Infrastructure SystemSample
Mobile MobileRequest
OpenTelemetry Span

 

Back to top