topic Re: Generic DB Query Plugin in Real User Monitoring

Generic DB Query Plugin

sagar_dalvi — Mon, 07 Nov 2022 12:26:24 GMT

Hi Team,

We implemented Generic DB query plugin in our environment, post implementation we added one query which is fetch payment history details like imps,neft,upi transactions count.

In further unable to get table output of the database in Dynatrace console.

Client need below output with the help of plugin:

1. IMPS, NEFT & UPI transaction count in table format in Dynatrace Dashboards.

It is possible to show transaction count in Dynatrace with the help of the plugin, Kindly assist for same.

Plugin Name: DB Generic Query(Running through AG)

Regards

Sagar Dalvi

Re: Generic DB Query Plugin

Mizső — Mon, 07 Nov 2022 13:05:30 GMT

Hi @sagar_dalvi,

You can do it. You can find the query results in the custom.db.query metric via Metrics or Data Explorer.

In order to split by transactions you should use at least on dimension. In my Oracle sample there are three dimensions you can reuse it with less dimension.

Here is the original query:

Here is the extension configuration for this query:

Here is a table with two dimensions: (Tranzakciós számok means transaction counts, details are the transaction types)

I hope it helps.

Best regards,

Mizső

Re: Generic DB Query Plugin

sagar_dalvi — Mon, 07 Nov 2022 14:07:50 GMT

Hi Mizső

I am using below query

can you help out for dimensions, i m using transfertype as dimension column for the value column getting confused.

Can you help with value column and dimension column parameters.

Unable to get custom.db.query metric in data explorer console.

Regards,

Sagar Dalvi

Re: Generic DB Query Plugin

Mizső — Mon, 07 Nov 2022 15:22:15 GMT

Hi @sagar_dalvi,

I would use you query like this:

select count(*) as count , t.tranfertype as transfertype
from .................... t
where t.transferdate >= sysdate - 5 / (24/60)
and t.transfertype = ('UPI','P2A'....)
group by t.transfertype

In the configuration the value colums would be count and dimension colums would be transfertype.

I would also switch on the debug log in the configuration and then I would chceck the support archive of the choosen active gate (you have already configured it in the extesnion).

In the support archive you can find the extension logs:

In these logs you can find useful information about the query runs and maybe you will find out the problem with the query.

Best regards,

Mizső

Re: Generic DB Query Plugin

sagar_dalvi — Tue, 08 Nov 2022 15:21:27 GMT

Thanks Mizső !!

It help me to get data from that DB Query, with your instructions.

Regards

Sagar Dalvi

Re: Generic DB Query Plugin

Mizső — Tue, 08 Nov 2022 17:19:48 GMT

Hi @sagar_dalvi,

I really happy to hear this great news.

Have a nice day.

Best regards,

Mizső

Re: Generic DB Query Plugin

davidraouf — Thu, 05 Jan 2023 12:47:48 GMT

Thanks for your support as

custom.db.query have no data

however i follow the steps

Re: Generic DB Query Plugin

Mizső — Thu, 05 Jan 2023 13:29:39 GMT

Hi @davidraouf,

I do not have experience with MQ SQL + db.qurey.

Could you please check this settings also?

https://www.dynatrace.com/support/help/shortlink/local-api#enable-the-oneagent-metric-api

I hope it helps.

Best regards,

Mizső

Re: Generic DB Query Plugin

eduardoferraz — Fri, 16 Jun 2023 17:37:27 GMT

Boa tarde @Mizső

Estou com o mesmo problema, e olhando na documentação, a opção no data explorer não é visível a métrica "custom.db.query"

Re: Generic DB Query Plugin

Mizső — Sun, 18 Jun 2023 14:42:36 GMT

Hi @eduardoferraz,

I recommend to check the support arcive logs.

Best regards,

Mizső