> 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/daily-job-runs-per-user.md). # Daily Job Runs per User ## What is a Daily Job Runs per User Report? The Daily Job Runs per User report provides a view of the count of DQ Jobs run in the Collibra DQ application by user, per day. You can filter this report by various criteria from a Filter Type dropdown list, as well as set a limit to the number of usernames, dates, and job runs 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

Reports icon in the left navigation pane.\ The Reports page opens. {% endstep %} {% step %} From the Reports page, select the **Daily Job Runs Per User** 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. From the Last x Days dropdown list, select one of the following options: * **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.

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.

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.

The chart and table update, based on your selections.

3. Proceed to step 4. * **All** - filter by all daily job runs and users. 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.

The chart and table update, based on your selections.

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

ellipsis icon. {% endstep %} {% step %} Click

**Chart Configuration**.The Chart Configuration window displays. {% hint style="info" %} As a best practice, keep the Chart Configuration as the default. {% endhint %} {% endstep %} {% step %} From the X-Axis Column dropdown list, select one of the following options: * **jobs** * **updtTsStr** * **username** {% endstep %} {% step %} From the Y-Axis Columns dropdown list, select one or more of the following options: * **jobs** * **updtTsStr** * **username** {% endstep %} {% step %} From the Chart Type dropdown list, select one of the following options: * **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 datasets and row counts, 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

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

and

icons, located bottom-right of the columns. {% endstep %} {% endstepper %} ## Sample SQL query You can use the following sample SQL query for a Job Runs per User report. ``` select updt_ts::date, username, count(*) from owlcheck_q where updt_ts > '2022-3-09' and username <> 'admin' group by updt_ts::date, username order by updt_ts asc ```