AppD Archive

Creating a dashboard using a script

CommunityUser
Splunk Employee
Splunk Employee

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 ?

0 Karma
1 Solution

Arun_Dasetty
Super Champion

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

View solution in original post

CommunityUser
Splunk Employee
Splunk Employee
Thanks a lot for all your efforts for answering my questions
0 Karma

CommunityUser
Splunk Employee
Splunk Employee
Thanks a lot Akumar for all the help , just one more thing , what if upgrading the app dynamics was an option , will that facility exists ??

There are multiple custom queries that the customer want to execute such as how many and what are the names and the transactions that were executed on certain database,to be displayed on a dashboard and refreshed every 5 minutes or so.
0 Karma

Arun_Dasetty
Super Champion

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

Arun_Dasetty
Super Champion

Hi,

We understood that customer already went through DB Mon Screens referred in below DB Mon feature section and that does not help,

image.png

image.png

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

0 Karma

CommunityUser
Splunk Employee
Splunk Employee

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 ?

0 Karma

Arun_Dasetty
Super Champion

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

0 Karma

CommunityUser
Splunk Employee
Splunk Employee

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 ?

0 Karma

Arun_Dasetty
Super Champion

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?

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...