APMSQL not returning metrics from Collectors

Document ID : KB000074770
Last Modified Date : 27/03/2018
Show Technical Document Details
Issue:
When I try to query Agent metrics connecting through MOM using APMSQL, it is not returning metrics from Collectors.
Environment:
Should be valid for all APM versions including latest 10.7
Cause:
1) The Token generated was not 'Public API' type
2) The Token generated was not by an 'Admin' user
3) Rest API is not enabled in MOM or Standalone EM IntroscopeEnterpriseManager.properties file:
introscope.public.restapi.enabled=false
    (default is not enabled)
Resolution:
1) Make sure the Token generated is 'Public API' type
2) Make sure the Admin user generates the Token
3) Rest API needs to be enabled in MOM IntroscopeEnterpriseManager.properties:
introscope.public.restapi.enabled=true
    (default is not enabled)