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)
Solved! Go to Solution.
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.
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.
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.
Thanks for your support as
custom.db.query have no data
however i follow the steps
I do not have experience with MQ SQL + db.qurey.
Could you please check this settings also?
I hope it helps.
Thanks Mizső !!
It help me to get data from that DB Query, with your instructions.
I really happy to hear this great news.
Have a nice day.