Splunk AppDynamics

Database User Account Health Rule Setup

Gregory_Barnes
New Member

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

Labels (1)
0 Karma

Hiroki_Ito
Contributor

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

Get Updates on the Splunk Community!

.conf25 Community Recap

Hello Splunkers, And just like that, .conf25 is in the books! What an incredible few days — full of learning, ...

Splunk App Developers | .conf25 Recap & What’s Next

If you stopped by the Builder Bar at .conf25 this year, thank you! The retro tech beer garden vibes were ...

Congratulations to the 2025-2026 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...