# NRQL Alerts examples

* NRQL is a custom New Relic Language that is very similar to the SQL Language

### AWS Applications

#### ELB HTTP codes:

```sql
SELECT average(aws.applicationelb.HTTPCode_ELB_5XX_Count) FROM Metric FACET entityName
```

#### ALB HTTP codes:

```sql
SELECT count(`aws.applicationelb.HTTPCode_ELB_5XX_Count`) FROM Metric FACET entityName
```

#### ALB HTTP codes based on name:

```sql
SELECT count(aws.applicationelb.HTTPCode_ELB_5XX_Count) FROM Metric WHERE displayName like '%NAME-HERE%'
```

#### Process Monitoring:

```sql
SELECT * FROM ProcessSample Where processDisplayName where processDisplayName like '%%'
```

```sql
SELECT count(*) FROM ProcessSample FACET entityName where processDisplayName LIKE 'aws-es-proxy'
```

#### RDS Free Space:

```sql
SELECT min(aws.rds.FreeLocalStorage) from Metric FACET entityName
```

#### K8S / EKS:

```sql
SELECT * from K8sClusterSample
```

#### Select from Incidents:

```sql
SELECT * FROM NrAiIncident where conditionName like '%Pod%'
```