How to get the TransactionName in below query ?
Facet to get the transaction name (which JSP)
Goal: I want to identify the JSP correlation with the CPU/User/Utilization and memory Utilization.
SELECT average(newrelic.timeslice.value) * 1000 AS
WHERE appName like ‘%%’
AND metricTimesliceName = ‘CPU/User/Utilization’ and scope like '%%'facet appName,metricTimesliceName since 1 hour ago
I was able to make below query work for metricTimesliceName like ‘Datastore/%’ with scope capturing the JSP name. But how to achieve the same for above CPU and Memory Utilization in Metric data.
There should be a way !
FROM Metric SELECT count(newrelic.timeslice.value) as ‘count’, average(newrelic.timeslice.value, exclusiveTime: true) as ‘Average, seconds’ WHERE appName like ‘%ABCDE%’ and scope like ‘WebTransaction/%’ and metricTimesliceName like ‘Datastore/%’ and metricTimesliceName like ‘%%’ LIMIT 100 FACET appName,scope, metricTimesliceName SINCE 1 hour ago