Alert Details Report

What is an Alert Details Report?

The Alert Details report provides a view of the details of all the alerts in the Collibra DQ application and the method by which they are sent. You can filter this report by various criteria from a Filter Type dropdown, as well as set a limit to the number of alert details you want to view, based on the filter you choose. You can also configure the kind of chart you want to use to view the data.

Steps

  1. Sign in to the Collibra DQ instance and click the reports icon Reports icon in the left navigation pane.
    The Reports page opens.

  2. From the Reports page, select the Alert Details link.

  3. To display results by filter type, select one of the following options from the Filter Type dropdown:

    • Last x Days - filter by last number of days.

      1. Select one of the following options from the Last x Days dropdown:

        • 1 day

        • 2 days

        • 7 days

        • 10 days

        • 15 days

        • 30 days

      2. In the Limit input field, enter a value to limit the number of top end results that display in the chart and data table.

        Note The chart and table update, based on your selections.

      3. Proceed to step 4.

    • Custom Range - filter by configuring a custom range.

      1. Select a from and to date range in the Date Range fields.

        Tip You can also select the icon, which displays a calendar, in which you can select a specific date.

      2. In the Limit input field, enter a value to limit the number of top end results that display in the chart and data table.

        Note The chart and table update, based on your selections.

      3. Proceed to step 4.

    • All - filter by all alerts and alert value formats.

      1. In the Limit input field, enter a value to limit the number of top end results that display in the chart and data table.

        Note The chart and table update, based on your selections.

      2. Proceed to step 4.

  4. Click Go.

  5. To configure the type of chart configuration and data you want to see in the chart, click the ellipsis icon.

  6. Click Chart Configuration.
    The Chart Configuration window displays.

    Note As a best practice, keep the Chart Configuration as the default.

  7. For the x-axis column, select one of the following options from the X-Axis Column dropdown:

    • alerts

    • alertFormatValue

  8. For the y-axis columns, select one or more of the following options from the Y-Axis Columns dropdown:

    • alerts

    • alertFormatValue

  9. For the type of chart you want to display, select one of the following options from the Chart Type dropdown:

    • Line

    • Area

    • Column

    • Scatter

  10. Click Save.
    The chart displays based on the criteria you selected. The table below the chart displays the specific alert details, based on your selections.

    Note To close the Chart Configuration window, click Cancel or the X in the upper-right corner of the window. You can hide or show the filter options by clicking the or icons, located to the right of the filter options.

    Tip To narrow your results in the data table, you can enter information in the Search field.

  11. Navigate the pages of your report by clicking the and icons, located bottom-right of the columns.

Sample SQL query

You can use the following sample SQL query for an Alert Details report.

Copy 
select alert_format_value, count(*) alerts
from alert_cond
group by alert_format_value
order by alerts desc limit 10