Alerts and Reports

The Add Alert feature allows users to configure and schedule alerts based on custom conditions and queries.

1. In the Workbench, click Settings at the top right corner of the screen and click Alerts and Reports to navigate to the list Alerts and Reports section. 
   
   

Add New Alerts

1. Click Alerts and click +ALERT to add a new alert. 
   
    
2. Click thearrow to provide the following General Information.
   1. Enter the Alert Name, Owner and Description of the alert.
   2. Click the toggle button to enable or disable the alert. 
      
       
3. Click thearrow to provide the following Alert Condition details.
   1. Select the Database from the dropdown list.
   2. Enter the SQL query that retrieves the data used to evaluate the alert condition.
   3. Choose the condition type under which the alert should be triggered.
   4. Enter the Threshold value to compare against the result of your SQL query. 
      
       
4. Click thearrow to provide the following Schedule details.
   1. Select Schedule Type from the dropdown.
   2. Under the Schedule field defines the recurrence intervals.
   3. Select the Timezone in which the alert time should be interpreted.
   4. Select Log Retention period to specify how long the alert execution logs should be retained.
   5. Enter the Grace period in seconds during which the alert won’t trigger again, even if conditions are met. 
      
       
5. Click thearrow to provide the following Notification methods.
   1. Select Notification Method from the dropdown menu.
   2. If u select Email from the Notification method dropdown then enter the Email of the recipients. 
      
       
6. Click Cancel to discard the alert configuration.
7. Click Add to save and activate the alert based on the specified settings.

Add Report

1. In the Alerts & Reports section, click the Reports option and click the +Reports button to add a new report. 
   
    
2. To add a report, you must fill out all the mandatory sections. First, fill in the general information section.
   1. Click thearrow to provide the following General Information.
   2. Enter the Alert Name, Owner, and Description of the alert.
   3. Click the toggle button to activate or deactivate the report. 
      
       
3. Click thearrow to provide the following Report contents details.
   1. Choose the type of content to include in the report.
   2. Choose which dashboard will be used to generate the report.
   3. Define a custom width (in pixels) for the screenshot of the dashboard.
   4. When checked, this option forces the report to fetch fresh data, bypassing any cached results. 
      
       
4. Click thearrow to provide the following Schedule details.
   1. Select Schedule Type from the dropdown.
   2. Under the Schedule field defines the recurrence intervals.
   3. Select the Timezone in which the alert time should be interpreted.
   4. Select Log Retention period to specify how long the alert execution logs should be retained.
   5. Enter the Grace period in seconds during which the alert won’t trigger again, even if conditions are met. 
      
       
5. Click thearrow to provide the following Notification methods.
   1. Select Notification Method from the dropdown menu.
   2. If u select Email from the Notification method dropdown, then enter the Email of the recipients. 
      
       
6. Click Cancel to discard the alert configuration.
7. Click Add to save and activate the alert based on the specified settings.