Not a customer? Click the 'Start a free trial' link to begin a 30-day SaaS trial of our product and to join our community.
Existing Cisco AppDynamics customers should click the 'Sign In' button to authenticate to access the community
02-03-2021 08:31 AM
Hoping this is the correct board to post this question. I need help in setting up a health rule for our Oracle database so I can be alerted if one of our application user accounts get locked. For the life of me I can't seem to find where I can define that. Any help would be greatly appreciated.
Thanks
Greg
07-20-2021 10:47 PM
Hi @Gregory.Barnes,
Database custom metrics can be used in this situation.
https://docs.appdynamics.com/21.7/en/database-visibility/monitor-databases-and-database-servers/conf...
You can create a custom metric by specifying SQL queries to run on the monitored database.
A custom metric with a number of locked users from the user table may work for you.
Then you can create a health rule and a policy to get an alert.
Please see the document below for alert and respond policy structure.
https://docs.appdynamics.com/21.7/en/appdynamics-essentials/alert-and-respond#AlertandRespond-Alerta...
As a side note, you can query pdb by <tablenamme>@<pdb name>.
Also, please remove semicolon at the end of the query.
e.g. select count(*) from ABC@XYZ
XYZ is PDB and ABC is the table name.
Best Regards,
Hiroki
User | Count |
---|---|
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
Thank you! Your submission has been received!
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form