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!

Uncovering Multi-Account Fraud with Splunk Banking Analytics

Last month, I met with a Senior Fraud Analyst at a nationally recognized bank to discuss their recent success ...

Secure Your Future: A Deep Dive into the Compliance and Security Enhancements for the ...

What has been announced?  In the blog, “Preparing your Splunk Environment for OpensSSL3,”we announced the ...

New This Month in Splunk Observability Cloud - Synthetic Monitoring updates, UI ...

This month, we’re delivering several platform, infrastructure, application and digital experience monitoring ...