Most data generated by integrations is available in New Relic One dashboards, where you can query your data using NRQL and build custom dashboards. The following tips and sample queries were created for New Relic-built integrations, but most will also apply to integrations built with the Integrations SDK.
For a general look at how to find and use integration data, see New Relic data types.
Get started with integration data
Here are some tips for finding and exploring your integration data in New Relic:
From the one.newrelic.com> Infrastructure > Third-party services page, select an integration dashboard. There, you can view the NRQL queries that generated a chart. For examples of NRQL queries for integration data, see the example queries.
When you create a useful query you'd like to add to your dashboard, select Add to dashboard.
Example NRQL queries
Here are some examples of NRQL queries that use integration data:
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 syntax.
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 syntax.
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
Integrations can generate metric, event, and inventory data, all of which are available for querying. Here are some tips for using the different types of integration data:
Tips for finding and using integration metric data:
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.
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 the data explorer.
For general information about events, see Event data.
Here are some tips for finding and using integration inventory data:
Some inventory data is added as attributes (key-value pairs) to this data. For example, the AWS EC2 integration collects awsRegion as inventory data; this would be found by querying the awsRegion attribute of the ComputeSample event type and provider Ec2Instance.
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.