Queries using NRQL (New Relic Query Language)

Queries take the general form of:

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.

Common Event Types By Agent:

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