Rule Updates per User

What is a Rule Updates per User Report?

The Rule Updates per User report provides a view of when a rule is inserted, updated, or deleted and applied to the dataset in the Collibra DQ application, by user for a specific time. You can filter this report by various criteria from a Filter Type dropdown, as well as set a limit to how many users and rules 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 in the left navigation pane.
   The Reports page opens.

2. From the Reports page, select the Rule Updates per User link.

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

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

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

        • 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. To limit the number of users that the chart displays, enter a number in the Limit field.

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

     3. Proceed to step 4.

   • All - filter by username and rules.

     1. To limit the number of users that the chart displays, enter a number in the Limit field.

        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 list:

   • rules

   • username

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

   • rules

   • username

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

   • Line

   • Area

   • Column

   • Scatter

10. Click Save.
    The chart displays based on the criteria you selected. The table below the chart displays the specific usernames and user clicks, 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 a User Activity report.

select user_nm, count(*) rules from rule_history 
where updt_ts > '2022-03-05'
and user_nm <> 'admin'
group by user_nm order by rules desc