User Activity Report

What is a User Activity Report?

The User Activity report provides a view of the number of clicks in the Collibra DQ application by user. You can filter this report by various criteria from a Filter Type dropdown, as well as set a limit to how many users 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 User Activity 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 user clicks.

      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:

    • username

    • userClicks

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

    • userClicks

    • 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.

Copy 
select username, count(*) user_clicks from activity_audit 
where audit_ts > '2022-03-05'
and username <> 'admin'
group by username
order by user_clicks desc limit 22