Analyze Alerts on the Alerts Dashboard
You can view and analyze auditing-based alerts from the Alerts dashboard.
About the Alerts Dashboard
By default, the Alerts dashboard shows you a summary of alert activity for the last seven days, for all target databases, in the form of charts and tables. You can filter the alerts as needed. The charts and tables are updated based on the filters that you set.
-
The Alerts summary chart helps you to see the severity of the alerts quickly by comparing the percentage of critical, high, and medium risk alerts.
-
The Open Alerts chart helps you to see the trend of open alerts by showing you the number of open alerts for the last seven days.
-
The Top 10 alert policies by volume chart helps you see what database and user changes are contributing to the most alerts by showing you a breakdown of what changes make up your alerts.
-
The Alerts summary tab shows you a table consisting of the number of target databases and alerts at each alert severity level (Critical, High, and Medium). It also shows totals for all alerts.
-
The Targets Summary tab shows you a table consisting of alert totals for each target database. You can view the number of open alerts and the number of critical, high, and medium risk alerts.
-
The Alert policy summary tab shows you a list of your alert policies, their corresponding severities, number of target databases, and number of alerts.
View and Filter the Alerts Dashboard
You may want to filter the data summarized on the Alerts dashboard. You can filter by compartment, time period, and/or target databases.
-
Under Data Safe - Database Security, select Alerts.
-
From the Compartment applied filter, select the compartment that contains the target databases for which you want to view alert summaries. Optionally, you can select Include child compartments.
-
From the Time Period applied filter, select the time period for the alert activity.
You can select Last 7 days, Last 2 weeks, Last month, or Custom range. If you select Custom range, specify the beginning and end.
-
Filter by target database or target database group using the Add filters workflow.
-
View the Alerts summary chart and Open Alerts chart.
-
View the Alerts Summary and Targets Summary tabs.
Analyze Alert Data
-
Under Data Safe - Database Security, select Alerts.
The Alerts landing page opens.
-
Filter the alerts as needed.
-
To view all the alerts based on a severity level, on the Alerts summary tab, select an alert severity link (Critical, High, Medium, or All Alerts).
The relevant alerts are displayed.
-
To view all the alerts based on a target database, select the Targets Summary tab, and then select a target database name.
-
At the top of the page, view the filters that are currently applied to the list of alerts.
These filters are the same as those that were applied to the dashboard. You can modify, remove, and add filters as needed. Filter types include Alert ID, Alert Severity, Alert Status, Alert Type, Client Host, Client ID, Client IP, Client Program, Created On, DB User, Object, Object Type, Operation, Operation Status, Operation Time, OS User, SQL Param, SQL Text, Target Name, Target Owner, and Updated.
-
View the summary totals based on the filters set.
There are totals for the total number of targets, the number of open, critical, high, medium, and low risk alerts; the total number of alerts, and the number of closed alerts.
-
To view the target database names, select Targets.
A Targets dialog box is displayed listing the target database names. Select Close to close the dialog box.
-
To filter the data in the table below the summary totals, select any of the other summary totals. For example, to view only critical alerts in the table, select the Critical total.
The table is automatically filtered.
-
In the table at the bottom of the page, view the list of alerts.
-
To add and remove columns from the alert list, from the Actions menu, select Manage Columns. The Manage Columns screen is displayed. Select/deselect columns, and then select Save Changes.The following columns are available:
-
Alert Name (displayed by default)
-
Alert Status (displayed by default)
-
Alert Severity (displayed by default)
-
Target Databases (displayed by default)
-
Created On (displayed by default)
-
Alert Policy
-
Operation
-
Operation Status
-
Operation Time
-
Alert Id
-