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.

Before you begin:

The short process shown here assumes that you have already followed the steps shown in the article in response to the question "How can I find out when my databases were accessed last?".

Instructions

Isolating actual users in the User Activity panel

Use a Value filer on the column 'User'

Step 1 Click on the column filter icon in the column 'User'.

Step 2 Select the 'Value Filters' option.

Select the values that you want to display (whose entries will remain in the grid))

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.

Uncheck the checkboxes of the user names you do not want to show

Step 5 Uncheck the checkboxes of the user names you do not want to show.

Step 6 Click 'OK'.

After the Values filter is applied, the only data remaining in the grid will be those entries whose selected values are present

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.