I would appreciate if someone could lend a hand with my query.
So I trying to get our DB2 response times split by IP-address and my current query template looks like this.
It currently splits the data by dt.entity.ipAddress and dt.entity.service but I would need the response time summarized by IP-address without the split on different database services.
Just couldn't figure out by myself how to archive that one.
timeseries interval: 1h, response_time = sum(dt.service.request.response_time),
by: { dt.entity.ipAddress, dt.entity.service },
filter: { in(dt.entity.service, classicEntitySelector("type(service),databaseVendor(\"DB2\")")) }
| sort arraySum(response_time) desc
| fieldsAdd entityAttr(dt.entity.service, "ipAddress")
| limit 50
