The Status Alerts tab allows you to view previously generated Status Alerts. A Status Alert is generated when the status of the specified product components matches the alert rule criteria. Use Status Alerts to identify and investigate possible issues with IDERA SQL Compliance Manager operations, such as deployed agents that may have stopped running.
Available actions
Page through alerts
Allows you to page through the list of alerts. Use the previous and next arrows to navigate from page to page, up and down the list.
Create customized view
Allows you to create a custom version of this tab. You can change the data that is displayed by selecting different columns. You also can save your customizations to view later.
Filters
Allows you to filter the listed alert messages by time span (for example, last seven days) or alert level (for example, high).
Enable Groups
Allows you to group alerts by a specific property, such as the audited SQL Servers affected by the alerts or the times the alerts occurred. Enable groups when you want to sort the alerts or focus on a particular alert attribute.
Alert Message
Allows you to view the message SQL Compliance Manager generated when this alert was triggered. Depending on your alert rule criteria, this message is written to the application event log and emailed to the specified email addresses. The Management Console displays an alert message only when the corresponding alert rule is configured to generate a message.
This action is available from the right-click context menu only.
Refresh
Allows you to update the Status Alerts list with current data.
Default columns
Icon
Provides a visual indication of the alert level so you can quickly scan the listed alerts for a specific alert type, such as a severe alert.
Date
Provides the date when the alert was generated.
Time
Provides the time when the alert was generated.
Level
Indicates the type of alert, such as Severe or Low. Use the alert level to help you identify critical issues, sort alerts by severity, and understand the overall health of your environment. You can define the alert using the Edit Alert Rule wizard.
Source Rule
Provides the name of the alert rule that generated this alert.
Rule Type
Provides the type of Status Alert that triggered this alert, such as a Collection Server or SQL Compliance Manager Agent rule.
Computer Name
Provides the name of the SQL Server computer hosting the affected instance. For example, if the SQL Compliance Manager Agent or Collection Server trace directory has reached its size limit, this column displays the name of the computer on which the trace directory folder resides.
SQL Server
Provides either the name of the audited SQL Server instance affected by this alert. For example, if the Collection Server has not received a heartbeat from the SQL Compliance Manager Agent, this column displays the name of the registered instance to which the agent was deployed.