| title | tags | translate | metaDescription | redirects | freshnessValidatedDate | |||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Understand and use data from infrastructure integrations |
|
|
New Relic infrastructure integrations: Where data appears in New Relic UI, how data is structured, and tips on how to use the data. |
|
2024-07-22 |
With our infrastructure integrations, you can monitor the performance of many popular services. Here are some tips on how to find, understand, and use data reported from infrastructure integrations.
The best way to understand infrastructure integrations's data and see what you can do with it is to enable an integration and explore the data in the New Relic UI.
Some recommendations for exploring:
- View dashboards:
- For AWS, Azure, and GCP data:
-
Search for your integration (Amazon Web Services, Azure, Google Cloud Plaform) and click the tile.
-
Navigate to a specific cloud entity type and click Dashboards.
- For all other integration dashboards, go to one.newrelic.com > All capabilities > Infrastructure and click your integration.
- For AWS, Azure, and GCP data:
- Query data: You can run custom queries and charts of your integration data. For more information, see Query data.
- Create alert conditions: See Alert conditions.
- Learn more about what metrics and inventory data an integration reports. To learn about that, see the documentation for a specific integration.
Learn how to build NRQL queries in our Intro to NRQL docs.
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`:```sql
SELECT sum('provider.volumeTotalWriteTime.Sum') FROM BlockDeviceSample WHERE provider = 'EbsVolume' FACET entityName
```
<Collapser id="azure-service-example" title="Azure Service Bus query example"
Here's a NRQL query for the maximum number of messages in an Azure Service Bus topic queue, faceted by resource group:
```sql
SELECT max(activeMessages.Maximum) FROM AzureServiceBusTopicSample FACET resourceGroupName
```
<Collapser id="azure-functions-example" title="Azure Functions query example"
Here's a NRQL query for Azure Functions, showing the count of executed functions over the past six hours by region over time:
```sql
SELECT sum(functionExecutionCount.Total) FROM AzureFunctionsAppSample FACET regionName TIMESERIES SINCE 6 hours ago
```
<Collapser id="azure-vms-example" title="Azure VMs query example"
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:
```sql
SELECT uniqueCount(vMName) FROM AzureVirtualMachineScaleSetSample FACET name SINCE 30 minutes ago COMPARE WITH 1 week ago
```
<Collapser id="nginx-example" title="NGINX query example"
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:
```sql
SELECT average(net.requestsPerSecond) FROM NginxSample TIMESERIES
```
For more on how to create queries, see [NRQL reference](/docs/query-your-data/nrql-new-relic-query-language/get-started/nrql-syntax-clauses-functions/).
<Collapser id="mysql-example" title="MySQL query example"
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:
```sql
SELECT max(net.maxUsedConnections) FROM MysqlSample
```
For more on how to create queries, see [NRQL reference](/docs/query-your-data/nrql-new-relic-query-language/get-started/nrql-syntax-clauses-functions/).
<Collapser id="inventory-change-example" title="Inventory change query example"
Here's an example of a query that groups inventory change events from the last day by the type of change:
```sql
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. For more on using NRQL queries, see Intro to NRQL.
Tips for finding and using integration metric data:* All integration data is attached to [a data type known as an event](/docs/data-apis/understand-data/new-relic-data-types/#event-data) (not to be confused with [events reported by integrations](/docs/integrations/new-relic-integrations/getting-started/introduction-infrastructure-integrations#events), which represent important activity in your host/service). This means that all integration data can be found via [metrics and events](/docs/query-your-data/explore-query-data/data-explorer/introduction-data-explorer). For more about these two basic New Relic data types, see [New Relic data collection](/docs/data-analysis/metrics/analyze-your-metrics/data-collection-metric-timeslice-event-data).
* Metric values are treated as <DNT>**attributes**</DNT>: key-value pairs attached to an [event](/docs/data-analysis/metrics/analyze-your-metrics/data-collection-metric-timeslice-event-data#event-data). 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](#metric).
<Collapser id="event-tips" title="Event data tips"
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](/docs/query-your-data/explore-query-data/data-explorer/introduction-data-explorer).
For general information about events, see [Event data](/docs/telemetry-data-platform/understand-data/new-relic-data-types/#event-data).
<Collapser id="event-tips" title="Inventory data tips"
When inventory data changes, an `InfrastructureEvent` event type is generated with a `format` value of `inventoryChange`. See the [query examples](#inventory-change-example) for an example of querying this data.
For general information about inventory data, see [Integration inventory data](/docs/integrations/new-relic-integrations/getting-started/understand-use-data-infrastructure-integrations).