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

[CommunityUser]

Hi ,

Can anybody help me with configuring database alerts to insert certain values into the database when the health rule violation occurs? Should I use custom action for that or remediation? Please help.

Regards,

NAzish Sayyed

[Yogesh_Chouk]

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

[Yogesh_Chouk]

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

[CommunityUser]

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 .

[Yogesh_Chouk]

Hi,

To update the column in oracle db, please take a look into below docs

https://docs.oracle.com/javadb/10.8.3.0/ref/rrefsqlj26498.html

Thanks,

Yogesh

^ Edited by @Ryan.Paredez Removed reference of sharing Log files. Please do not share or copy and paste your log files into the community for security reasons.

[CommunityUser]

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.