> For the complete documentation index, see [llms.txt](https://docs.collibra.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.collibra.com/data-quality-self-hosted/core-concepts/reports/alert-details-report.md).

# 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

{% stepper %}
{% step %}
Sign in to the Collibra DQ instance and click the <img src="https://4121921244-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWCrP7Albs8DfJjIQxUxw%2Fuploads%2Fgit-blob-0c20a262939f347f6b5a8337f3a456ed9586b995%2Fdq-reports-icon.png?alt=media" alt="reports icon" data-size="line"> Reports icon in the left navigation pane.\ <i class="fa-chevrons-right">:chevrons-right:</i> The Reports page opens.
{% endstep %}

{% step %}
From the Reports page, select the **Alert Details** link.
{% endstep %}

{% step %}
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.

     <div data-gb-custom-block data-tag="hint" data-style="info" class="hint hint-info"><p>The chart and table update, based on your selections.</p></div>
  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.

     <div data-gb-custom-block data-tag="hint" data-style="success" class="hint hint-success"><p>You can also select the <img src="https://4121921244-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWCrP7Albs8DfJjIQxUxw%2Fuploads%2Fgit-blob-43c1dbae75be7b73687f605692fc2b37943d3066%2Fdq-calendar-icon.png?alt=media" alt="" data-size="line"> icon, which displays a calendar, in which you can select a specific date.</p></div>
  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.

     <div data-gb-custom-block data-tag="hint" data-style="info" class="hint hint-info"><p>The chart and table update, based on your selections.</p></div>
  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.

     <div data-gb-custom-block data-tag="hint" data-style="info" class="hint hint-info"><p>The chart and table update, based on your selections.</p></div>
  2. Proceed to step 4.
     {% endstep %}

{% step %}
Click **Go**.
{% endstep %}

{% step %}
To configure the type of chart configuration and data you want to see in the chart, click the ![](https://4121921244-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWCrP7Albs8DfJjIQxUxw%2Fuploads%2Fgit-blob-e471d6e6763e2ebd4b26dbbadfb0af53fce9cf0c%2Fdq-ellipsis-icon.png?alt=media)ellipsis icon.
{% endstep %}

{% step %}
Click ![](https://4121921244-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWCrP7Albs8DfJjIQxUxw%2Fuploads%2Fgit-blob-997001e32eb8d6643df667aac5e4ba31baf9a7ea%2Fdq-admin-gear-icon.png?alt=media) **Chart Configuration**.The Chart Configuration window displays.

{% hint style="info" %}
As a best practice, keep the Chart Configuration as the default.
{% endhint %}
{% endstep %}

{% step %}
For the x-axis column, select one of the following options from the **X-Axis Column** dropdown:

* **alerts**
* **alertFormatValue**
  {% endstep %}

{% step %}
For the y-axis columns, select one or more of the following options from the **Y-Axis Columns** dropdown:

* **alerts**
* **alertFormatValue**
  {% endstep %}

{% step %}
For the type of chart you want to display, select one of the following options from the **Chart Type** dropdown:

* **Line**
* **Area**
* **Column**
* **Scatter**
  {% endstep %}

{% step %}
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.

{% hint style="info" %}
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 <img src="https://4121921244-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWCrP7Albs8DfJjIQxUxw%2Fuploads%2Fgit-blob-8ea5f15b8759547a2f75120a5c11bf3fd99f243b%2Fdq-hide-arrow-icon.png?alt=media" alt="" data-size="line"> or <img src="https://4121921244-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWCrP7Albs8DfJjIQxUxw%2Fuploads%2Fgit-blob-e313b3b9a0d71eb97cc8e5fdacfc2b94d749322e%2Fdq-show-arrow-icon.png?alt=media" alt="" data-size="line"> icons, located to the right of the filter options.
{% endhint %}

{% hint style="success" %}
To narrow your results in the data table, you can enter information in the Search field.
{% endhint %}
{% endstep %}

{% step %}
Navigate the pages of your report by clicking the <img src="https://4121921244-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWCrP7Albs8DfJjIQxUxw%2Fuploads%2Fgit-blob-0c37423f41105659535aad8c652febf274e81249%2Fdq-previous-arrow-icon.png?alt=media" alt="" data-size="line"> and <img src="https://4121921244-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWCrP7Albs8DfJjIQxUxw%2Fuploads%2Fgit-blob-6a7c7a806e6f4e24a51783c46471c3a50bc1d56b%2Fdq-next-arrow-icon.png?alt=media" alt="" data-size="line"> icons, located bottom-right of the columns.
{% endstep %}
{% endstepper %}

## Sample SQL query

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

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