Generic DB Query Plugin

[sagar_dalvi]

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

[Mizső · Accepted solution]

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ő

[sagar_dalvi]

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

[Mizső]

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ő

[davidraouf]

Thanks for your support as 

custom.db.query have no data 

however i follow the steps

[Mizső]

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ő

[sagar_dalvi]

Thanks Mizső !!

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

Regards

Sagar Dalvi

[Mizső]

Hi @sagar_dalvi,

I really happy to hear this great news.

Have a nice day.

Best regards,

Mizső

[eduardoferraz]

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"

[Mizső]

Hi @eduardoferraz,

I recommend to check the support arcive logs.

Best regards,

Mizső