APM SQL not returning query results from Collectors

book

Article ID: 131509

calendar_today

Updated On:

Products

CA Application Performance Management Agent (APM / Wily / Introscope) INTROSCOPE

Issue/Introduction

APMSQL query was returning results from the MOM but not  the Collector

Cause

The User running the query is an EEM or an LDAP user. However, the EEM/LDAP authentication is only configured on the MOM and not Collectors. 

Environment

All supported APM releases.

Resolution

As a workaround, copy the EM_HOME/config/domains.xml, users.xml and realms.xml  files and any certificates needed for the EEM or LDAP server connection from the MOM to Collectors.

Additional Information

As an alternative, do not connect directly to the collector. Instead, get the same values from MOM which will authenticate and distribute properly. And then use a filter ("WHERE") to narrow the results only for that collector.