Separate 'actual' user activity from server activity
Separate 'actual' user activity from server activity
Q | I've found out when my databases were accessed by using the User Activity Analyzer, how can I make sure that I am only seeing the activity of actual users? |
A | Once you've retrieved the user activity data, you're almost there. By filtering the user names you can quickly take names such as servers out of the equation, leaving you with the true list of actual users. |
Isolating actual users in the User Activity panel
| Step 1 Click on the column filter icon in the column 'User'.
Step 2 Select the 'Value Filters' option. |
| Step 3 In the opened dialog, find the names that you do not want to show; in this case, you want to find any names that are not actual users.
Step 4 The column 'Selected' will indicate the names currently selected with a checkmark. |
| Step 5 Uncheck the checkboxes of the user names you do not want to show.
Step 6 Click 'OK'. |
| With the 'Values' filter now applied, only the user activity for actual users will be displayed. Grid rows containing user activity data linked to non-selected names will be hidden. |