Java (Java Agent, Installation, JVM, and Controller Installation)

cancel
Showing results for 
Search instead for 
Did you mean: 

how to set up Database alert(to insert value in database table ) when health rule violation occur

Explorer

how to set up Database alert(to insert value in database table ) when health rule violation occur

Hi ,

        Can anybody help me with configuring database alerts to insert certain values into database when health rule violation occur.should i use custom action for that or remediation?Please help.

Regards,

NAzish Sayyed

how to set up Database alert(to insert value in database table ) when health rule violation occur
5 REPLIES
Employee

Re: how to set up Database alert(to insert value in database table ) when health rule violation occu

Hi NAzish,

 

As per your query, we understand you are trying to update the controller database when the health rule violates. Please confirm. We do not recommend to use insert/update query in the database. Could you please let us know the use case or let us know if there is any disconnect.

You can use any of the actions as per your requirement to trigger alerts.

For more information-

https://docs.appdynamics.com/display/PRO44/Custom+Actions

https://docs.appdynamics.com/display/PRO44/Remediation+Scripts

 

Thanks,

Yogesh

Explorer

Re: how to set up Database alert(to insert value in database table ) when health rule violation occu

Hi Yogesh,
 
Following is the condition are to fulfilled upon Health rule violatio in a particular node.
 
       1)date , time  and count of occurence of health rule violation condition 
         to be inserted into application database for auditing
       2)A particular update script should be running upon each occurence of    health rule violation conditon.
 
       How to use custom Action to run a script in a particular database(where i can specify database connectio parameter).
 
Regards,
Nazish Sayyed.
Explorer

Re: how to set up Database alert(to insert value in database table ) when health rule violation occu

Hi Yogesh,
Following is the condition are to fulfilled upon Health rule violatio in a particular node.

1)date , time and count of occurence of health rule violation condition
to be inserted into application database for auditing
2)A particular update script should be running upon each occurence of health rule violation conditon.



How to use custom Action to run a script in a particular database(where i can specify database connectio parameter).


Regards,
Nazish Sayyed.
Employee

Re: how to set up Database alert(to insert value in database table ) when health rule violation occu

Hi,

 

Can you please confirm if you are referring to the controller database here. If yes, we do not recommend to update controller database as mentioned. If not, please write the custom scripts.

 

To build custom actions, please go through the below documentation.

https://docs.appdynamics.com/display/PRO44/Build+a+Custom+Action

 

Thanks,

Yogesh

Explorer

Re: how to set up Database alert(to insert value in database table ) when health rule violation occu

Hi Yogesh,

                 I want to update my application's database with the number of times a particular service is down.So for that i've created a bat file in windows and trying to run it with custom script but it shows failed excecution in event section of application dashboard.Can you please guide me where to see custom action's log and how to update a particular  column in oracle database on health rule violation.

 

Please see the attachment .Capture.PNG