Hi There
In simple words, the customer wants to monitor the output of a certain query on one of his databases that is being monitored by database agent.
The output of that is a table showing certain columns and values for each day,
Is there any possible way to do that ?
Hi,
Upgrading contorller will not help as such feature does not exists. Regarding other query, Ask customer to navigate to target JDBC backend dashboard (AppServers -> Databases -> double click <jdbc backend> in list to navigsate to backend dashbord) and now click the link between backend and tier icon and in popup window in Controller UI , selet "business transactions"
this will give tab that will list All BTs making calls to the target BT, OR ask customer to try the following:
- navigate to Analyze -> Metric browser
- expand "Business transaction performance" -> Business transacions -> <exand one target tier > -> <expand one of the BT > -> external calls -> select target JDBC Backend and right click and select "Copy REST URL" option on CPM|ART ms metric
- and now hit the copied URL in another browser tab
- now remove BT name string and tier name string in URL with asterisk symbol ,
- the result rest api response is what customer is looking for that will list all BTs from all tiers making calls to target jdbc with duration-in-ms=<time-trend-period-in-mts>
Hope that information helps
Hi,
Upgrading contorller will not help as such feature does not exists. Regarding other query, Ask customer to navigate to target JDBC backend dashboard (AppServers -> Databases -> double click <jdbc backend> in list to navigsate to backend dashbord) and now click the link between backend and tier icon and in popup window in Controller UI , selet "business transactions"
this will give tab that will list All BTs making calls to the target BT, OR ask customer to try the following:
- navigate to Analyze -> Metric browser
- expand "Business transaction performance" -> Business transacions -> <exand one target tier > -> <expand one of the BT > -> external calls -> select target JDBC Backend and right click and select "Copy REST URL" option on CPM|ART ms metric
- and now hit the copied URL in another browser tab
- now remove BT name string and tier name string in URL with asterisk symbol ,
- the result rest api response is what customer is looking for that will list all BTs from all tiers making calls to target jdbc with duration-in-ms=<time-trend-period-in-mts>
Hope that information helps
Hi,
We understood that customer already went through DB Mon Screens referred in below DB Mon feature section and that does not help,
if that is the case, Can you see if issueing the script and manippulating the script output and resendign as custom metrics in target format using machine agent custom metrics features helps here,report as custom metrics to metric browser in UI so that you create dashboard using those metrics:
https://docs.appdynamics.com/display/PRO41/Build+a+Monitoring+Extension+Using+Scripts
Thanks for replying back, in such no time.
However he have multiple scripts that he would like it is results appears in the dashboard section of AppDynamics.
The queries on the database may return with a table , value , etc.
What is installed is
AppDynamics Controller 4.0.4
Appdynamics for Database
Is there another way to do it other than building an extension ?
Hi,
We understood the DB Mon UI features does not meet as you are using 4.x version UI and apart from manipulating custom script output and showing in target format in custom metrics that can be reused in metric browser in UI, we do not see any other option at this point as per my knowledge
Thanks for your information.
Is it possible to guide me where are the queries that the database agent excute to get the results that he can get, and try to inject the queries along with it so it can fetch the data required ?
Hi ,
We see the new query is internal to the AD DB agent implementation, request you to ask queries specific to db agent feature funtionality issues
Also to be queries what exact output you are expecting so that we will see if the query is in general if we could answer?