topic Re: Querying a bind variables to user in Dashboard, metric etc in Log Analytics

Querying a bind variables to use in dashboards

abhijitmorye — Thu, 18 Dec 2025 08:44:45 GMT

Hello Team,

We have enabled the bind variable for one of our tenants, and we are seeing the values of the bind variables in Dynatrace. However, I want to know where these values of bind variables are stored in Dynatrace.

I am trying to find it in logs/spans, but have not been able to. Is there any way to use DQL to fetch the values of bind variables for each query in logs?

Thank you so much.

Re: Querying a bind variables to user in Dashboard, metric etc

marco_irmer — Thu, 08 May 2025 22:03:39 GMT

The bind variable values are stored as part of the spans, specifically in the db.query.parameters field. You can find the complete description of how database client spans are stored in Grail at https://docs.dynatrace.com/docs/discover-dynatrace/references/semantic-dictionary/model/trace#database-client-spans.

I hope that helps.

Re: Querying a bind variables to user in Dashboard, metric etc

abhijitmorye — Fri, 09 May 2025 05:40:58 GMT

HelloMarco,

Thanks for your message, however I am not able to view this db.query.paramaters in the spans. Below is the snapshots showing the names of the columns that I am currently seeing in the Dynatrace.

As you can see, I am not able to view the db.query.parameters in the list of columns.

trace.id

span.id

dt.entity.host

dt.entity.host_group

dt.entity.service

dt.entity.process_group

dt.entity.process_group_instance

dt.host_group.id

host.name

db.system

http.server_name

aggregation.count

aggregation.duration_max

aggregation.duration_min

aggregation.duration_samples

aggregation.duration_sum

aggregation.exception_count

aggregation.parallel_execution

code.call_stack

code.function

code.namespace

db.affected_item_count

db.namespace

db.operation.name

db.query.text

db.result.duration_sum

db.result.exception_count

db.result.execution_count

dt.agent.module.id

dt.agent.module.type

dt.agent.module.version

dt.agent.module.version_short

dt.ingest.size

dt.openpipeline.pipelines

dt.openpipeline.source

dt.retain.size

dt.system.monitoring_source

duration

end_time

java.main.class

process.executable.name

process.executable.path

process.pid

sampling.threshold

server.address

server.port

server.resolved_ips

servlet.context.name

servlet.context.path

span.is_subroutine

span.kind

span.name

span.parent_id

span.timing.cpu

span.timing.cpu_self

start_time

subtrace.id

supportability.alr_sampling_ratio

supportability.atm_sampling_ratio

thread.id

thread.name

weblogic.cluster.name

weblogic.domain.name

weblogic.home

weblogic.server.name

Re: Querying a bind variables to user in Dashboard, metric etc

marco_irmer — Fri, 09 May 2025 15:37:15 GMT

If you are using DQL, then it may be necessary to use the fieldsAdd command to ensure the column is there. You may also wish to add a filter to only list spans that actually have data in this field.

A simple example query might look like this:

fetch spans | filter isNotNull(db.query.parameters) | fieldsAdd db.query.parameters

If no spans come up, then it might be time to engage support for additional investigation

Re: Querying a bind variables to user in Dashboard, metric etc

abhijitmorye — Thu, 15 May 2025 12:02:26 GMT

Thanks for the query. I ran the same query but did not find any column named db.query.paramaeters. We are going to raise this as support ticket with Dynatrace.

Thanks once again.

Re: Querying a bind variables to user in Dashboard, metric etc

PierreGutierrez — Mon, 16 Jun 2025 17:52:35 GMT

Hi @abhijitmorye @marco_irmer

The field "db.query.parameters" is correct.
But its important to now that Bind Variable are considered Data sensible, for that reason it's necessary to configure permission to "builtin-sensitive-spans"

ALLOW storage:fieldsets:read WHERE storage:fieldset-name="builtin-sensitive-spans"

More Information : https://docs.dynatrace.com/docs/shortlink/assign-bucket-table-permissions#field-permissions

Also when you create a policy with that permission , you need to assign in your group and then try to read again the field. db.query.parameters

Re: Querying a bind variables to user in Dashboard, metric etc

Malaik — Sun, 01 Mar 2026 13:16:06 GMT

Dear @marco_irmer
Is there a way to capture and display those variables in Dynatrace Managed.

Im capturing them in the traces, but how can I display in Dashboards?

Thanks,

Re: Querying a bind variables to user in Dashboard, metric etc

Julius_Loman — Mon, 02 Mar 2026 07:21:30 GMT

@Malaik, that's unfortunately not possible as of today, and most likely won't be available in Managed. I recommend trying to capture the values using request attributes (if that's possible in your case_ and then using a calculated service metric with request attribute value as a dimension. That's probably the closest you can do. But it might not fit your case.

Re: Querying a bind variables to user in Dashboard, metric etc

Malaik — Tue, 03 Mar 2026 10:59:36 GMT

Thanks

Yes this what Im working with the team,

Thanks