Understand and use data from infrastructure integrations

Here's a NRQL query for the AWS EBS service, showing the total write time metric, faceted by entityName:

SELECT sum('provider.volumeTotalWriteTime.Sum') FROM BlockDeviceSample WHERE provider = 'EbsVolume' FACET entityName

Here's a NRQL query for the maximum number of messages in an Azure Service Bus topic queue, faceted by resource group:

SELECT max(activeMessages.Maximum) FROM AzureServiceBusTopicSample FACET resourceGroupName

Here's a NRQL query for Azure Functions, showing the count of executed functions over the past six hours by region over time:

SELECT sum(functionExecutionCount.Total) FROM AzureFunctionsAppSample FACET regionName TIMESERIES SINCE 6 hours ago

Here's a NRQL query for Azure VMs that compares the count of VM events over the past thirty minutes with the same time a week ago:

SELECT uniqueCount(vMName) FROM AzureVirtualMachineScaleSetSample FACET name SINCE 30 minutes ago COMPARE WITH 1 week ago

Here's an example of a query that you might run on your NGINX integration data and place in a dashboard. This query creates a chart showing the average value of NGINX requests per second over time:

SELECT average(net.requestsPerSecond) FROM NginxSample TIMESERIES

For more on how to create queries, see NRQL reference.

Here's an example of a query that you might run on your MySQL integration data. This query generates a chart showing the maximum number of used MySQL connections:

SELECT max(net.maxUsedConnections) FROM MysqlSample

For more on how to create queries, see NRQL reference.

Here's an example of a query that groups inventory change events from the last day by the type of change:

SELECT count(*) FROM InfrastructureEvent WHERE format='inventoryChange' FACET changeType SINCE 1 DAY AGO

Tips for finding and using integration metric data:

• All integration data is attached to a data type known as an event (not to be confused with events reported by integrations, which represent important activity in your host/service). This means that all integration data can be found via metrics and events. For more about these two basic New Relic data types, see New Relic data collection.

• Metric values are treated as attributes: key-value pairs attached to an event. For example, the MySQL integration has an 'active connections' metric; this would be found by querying the connectionsActive attribute of the MysqlSample event.

  For general information about metrics, see Integration metric data.

Here are some tips for finding and using integration event data when querying:

• Most integration events are inventory change events. When inventory is changed, it generates an InfrastructureEvent with a format value of inventoryChange.

• Integration data can be found via metrics and events.

  For general information about events, see Event data.

When inventory data changes, an InfrastructureEvent event type is generated with a format value of inventoryChange. See the query examples for an example of querying this data.

For general information about inventory data, see Integration inventory data.