How to find customer schema in APM?

Elastic Observability APM
1

Kibana version: 6.8

Elasticsearch version: 6.8

APM Server version: 6.8

APM Agent language and version: Java 8

Browser version: Firefox 66.0.3 (64-bit)

Original install method (e.g. download page, yum, deb, from source, etc.) and version: binary files from elastic.co

Fresh install or upgraded from other version? fresh

Description of the problem including expected versus actual behavior. Please include screenshots (if relevant):
How to find customer schema in APM? In the database statement we can only see the table in the query. Is there any way to find schema name for a query? It'd help a lot in the analysis!

2

How can the schema be retrieved? Via https://docs.oracle.com/javase/8/docs/api/java/sql/Connection.html#getSchema--?

3

How do I integrate it with ELK APM? Do I have to run a script, add a field or ingest a pipeline?
Thanks.

4

If the schema is within your DB query, you can use an ingest processor to extract it. If it's not available there, we'd need to add some logic to the agent to capture it.

5

It is not in the query.

Can you please specify and elaborate on what kind of logic I can use and how?

6

This requires changes in the within the agent, it's nothing you can do within your application.

Can you verify that Connection#getSchema returns the expected schema?

If so, we could make a change here to also capture the schema:

However, it also requires changes in the Intake API so that the APM Server recognizes and correctly indexes that field.

7

This topic was automatically closed 20 days after the last reply. New replies are no longer allowed.