junaidwily

Query Data from APM SQL using SQuirreL

Discussion created by junaidwily Champion on Aug 24, 2017
Latest reply on Aug 25, 2017 by Hallett_German

Does any one try to query date using APMSQL using SQuirrelL.

I am running following query which is working fine

 

SELECT   agent_name ,   
        metric_path ,   
        metric_attribute ,   
        Avg ( agg_value )   CI   
FROM     numerical_metric_data   
WHERE    frequency   >=   15000   
        AND   metric_path   LIKE   'SAPAgent|Store|com.controllers.pages.PageController%'   
        AND   agent_name   =   'cdcscmap20_2017'   
        AND   ts   BETWEEN   {ts '2017-08-20 12:00:00.0'}   AND   
                       {ts '2017-08-23 12:00:00.0'}   
GROUP    BY   agent_name ,   
           metric_path ,   
           metric_attribute

 

 

but when I am trying query data from Custom Metric Agent I am not getting any results

 

SELECT   agent_name ,   
        metric_path ,   
        metric_attribute ,   
        Avg ( agg_value )   CI   
FROM     numerical_metric_data   
WHERE    frequency   >=   15000   
        AND   metric_path   LIKE   'ABCOrder Perfection Rate %'   
        AND   agent_name   =   'Custom Metric Agent (Virtual)'   
        AND   ts   BETWEEN   '2017-08-20 12:00:00.0'   AND   
                       '2017-08-23 12:00:00.0'   
GROUP    BY   agent_name ,   
           metric_path ,   
           metric_attribute

 

I also try to use  AND   metric_path   LIKE   'Business service Reliability|Perfection Rate|ABCOrder|ABCOrder Perfection Rate %'  

but didn't work

Attachments

Outcomes