Anypoint Monitoring Metrics API

AMQL Query Examples

Time series of P99 of Request Latency for all applications in given environment

SELECT timestamp, "app.id", PERCENTILE("response_time", 0.99) FROM "mulesoft.app.inbound" WHERE "sub_org.id" = 'some-business-group-id' AND "env.id" = 'some-env-id' AND timestamp BETWEEN 1742475180000 AND 1742478780000 GROUP BY "app.id" ORDER BY timestamp DESC TIMESERIES PT5M

Time series of Request volume for all applications in given environment

SELECT timestamp, "app.id", SUM("requests") FROM "mulesoft.app.inbound" WHERE "sub_org.id" = 'some-business-group-id' AND "env.id" = 'some-env-id' AND timestamp BETWEEN 1742475180000 AND 1742478780000 GROUP BY "app.id" ORDER BY timestamp DESC TIMESERIES PT5M

Time series of Request volume by response code group for a single API in given environment

SELECT timestamp, COUNT(requests), "http.status_code_group" FROM "mulesoft.api.summary" WHERE "sub_org.id" = 'some-business-group-id' AND "env.id" = 'some-env-id' AND "api.instance.id" = 'some-api-instance-id' AND timestamp BETWEEN 1742476800000 AND 1742480400000 GROUP BY "http.status_code_group" ORDER BY timestamp desc TIMESERIES PT5M

Count of API requests from particular geo location for a single API in given environment

SELECT "client.geo.city.name", "client.geo.country.name", COUNT(requests) FROM "mulesoft.api.geo_location" WHERE "sub_org.id" = 'some-business-group-id' AND "env.id" = 'some-env-id' AND "api.instance.id" = 'some-api-instance-id' AND timestamp BETWEEN 1742476800000 AND 1742480400000 GROUP BY "client.geo.city.name", "client.geo.country.name"