unable to get metric with SQL API.

Products

• CA Application Performance Management (APM / Wily / Introscope)

Issue/Introduction

You are unable to get metric with SQL API from an APM cluster environment.

Query examples:

Request Body:
    {"query" : "select agent_host, agent_process, avg(agg_value) from metric_data where metric_path like '%GC Heap:Bytes In Use%' group by agent_host, agent_process"}

Request Body:
    {"query" : "SELECT * FROM metrics WHERE agent_name = '<agent name>'"}

Resolution

Token created with APM local admin account resolved the issue.