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.

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: