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!

Developer Spotlight with Brett Adams

In our third Spotlight feature, we're excited to shine a light on Brett—a Splunk consultant, innovative ...

Index This | What can you do to make 55,555 equal 500?

April 2025 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this ...

Say goodbye to manually analyzing phishing and malware threats with Splunk Attack ...

In today’s evolving threat landscape, we understand you’re constantly bombarded with phishing and malware ...