Oracle® Real User Experience Insight User's Guide 12c Release 1 for Linux x86-64 Part Number E35689-02 |
|
|
PDF · Mobi · ePub |
This appendix describes how you can analyze user events. The structure of the database table used by it is also explained.
The RUEI database contains information about user events (such as when a user opens a report, consults a KPI alert log, or logs on and off). This information can be used for a wide variety of purposes, such as determining how often a particular report is opened or downloaded by users, or which is the most frequently accessed Data Browser group. In this way, you can optimize your RUEI installation to best meet the needs of your users.
The recording of user events is controlled by the user_events_enabled
setting within the uxs_config
table. When set to 1 (the default), user events are recorded; when set to 0, user events are not recorded.
By default, information about user events is held in the database for a maximum of 31 days. This is controlled by the db_max_user_events
entry within the uxs_config
table. To modify either of these settings, do the following:
Logon to the Reporter system, and issue the following command as the root
user:
# su - moniforce # sqlplus /@uxinsight
Issue the following command to enable or disable user event recording:
SQL> UPDATE UXS_CONFIG SET VALUE='N' WHERE NAME='uxs_config'
where N
specifies whether user event recording is enabled (1), or disabled (0).
Issue the following command to modify the user event retention setting:
SQL> UPDATE UXS_CONFIG SET VALUE='N' WHERE NAME='db_max_user_events'
where N
specifies the maximum number of days for which user event information should be stored. Note that this setting has an impact on database usage.
This section explains the structure of the database table generated by RUEI for user events. This table is located in the database (local or remote) used by your installation. It can be accessed through SQL queries.
The UXS_USER_EVENTS table, shown in Table U-1, contains user event information.
Column | Type | Description |
---|---|---|
ID |
NUMBER |
Unique ID used to identify the user event. |
STAMP |
TIMESTAMP |
Time (in UTC format) when event was performed by user. |
USERNAME |
VARCHAR2 (255 BYTE) |
Logon name of user. |
CODE |
NUMBER |
This is an event code. |
EVENT |
VARCHAR2 (4000 BYTE) |
Brief description of the event. |
The possible CODE events and their associated descriptions are shown in Table U-2.
Table U-2 UXS_LANG_CATALOG_DATA Table
Code | Description |
---|---|
0 |
User logon. |
1 |
User logout. |
2 |
Load/reload Dashboard tab. |
3 |
Added new dashboard (%1%s). |
4 |
Updated dashboard (%1$s). |
5 |
Removed dashboard (%1$s). |
6 |
Load/reload Report tab. |
7 |
View report (%1$s). |
8 |
Load/reload preview report (%1$s). |
9 |
Save report (%1$s). |
10 |
Save report as new (%1$s). |
11 |
Download report as PDF (%1$s). |
12 |
Download report as CSV (%1$s). |
13 |
Download report as TSV (%1$s). |
14 |
Download report as XLS (%1$s). |
15 |
Download report as XML (%1$s). |
16 |
Add report to Favorites (%1$s). |
17 |
Remove report from Favorites (%1$s). |
18 |
Toggle report %1$s mailing (%2$s). |
19 |
Remove report from %1$s mailing (%2$s). |
20 |
Send %1$s mailing now. |
21 |
Load/reload Browse tab. |
22 |
Select graph (%1$s). |
23 |
Select graph category (%1$s). |
24 |
Select group (%1$s). |
25 |
Load/reload diagnostics. |
26 |
Browse report (%1$s). |
27 |
Load/reload KPI overview tab (%1$s). |
28 |
Load/reload KPI overall alert log. |
29 |
Show KPI specific alert log (%1$s). |
30 |
Load/reload KPI correlation (%1$s). |
31 |
User %1$s has been added. |
32 |
User %1$s has been removed. |
33 |
Application %1$s has been added. |
34 |
Application %1$s has been removed. |
35 |
Service %1$s has been added. |
36 |
Service %1$s has been removed. |
37 |
Suite %1$s has been added. |
38 |
Suite %1$s has been removed. |
39 |
Collector profile %1$s has been added. |
40 |
Collector profile %1$s has been removed. |
41 |
Collector %1$s has been registered in profile %2$s. |
42 |
Collector %1$s from profile %2$s has been unregistered. |
43 |
Collector %1$s in profile %2$s has been restarted. |
44 |
Collector %1$s in profile %2$s has been disabled. |
45 |
Collector %1$s has been moved to profile %2$s. |
46 |
Traffic filter in profile %1$s has been changed to %2$s. |
47 |
VLAN filter in profile %1$s has been changed to %2$s. |
48 |
Port numbers (%1$s) in profile %2$s has been added. |
49 |
Port numbers (%1$s) in profile %2$s has been removed. |
50 |
The IP filter (%1$s) has been added in profile %2$s. |
51 |
The IP filter (%1$s) has been removed from profile %2$s. |
52 |
User account %1$s has been enabled. |
53 |
User account %1$s has been disabled. |
54 |
User account %1$s has been locked. |
55 |
User account %1$s has been unlocked. |
56 |
Maximum login attempt reached for user account %1$s. |
57 |
The password for user %1$s has been expired. |
58 |
The initial password for user %1$s has expired. |
59 |
The minumum password length has been changed to %1$s. |
60 |
The maximum password duration has been changed to %1$s. |
61 |
Remove report (%1$s). |
62 |
URL prefix %1$s with action: %2$s has been added. |
63 |
URL prefix %1$s with action: %2$s has been removed. |
64 |
URL prefix %1$s with action: %2$s has been updated. |
65 |
Default replay action has been changed to %1$s. |
66 |
Replay IP range action has been changed to %1$s. |
67 |
Replay IP range %1$s has been added. |
68 |
Replay IP range %1$s has been removed. |
69 |
Replay all IP ranges have been removed. |
70 |
Replay IP range %1$s has been changed. |
71 |
Replay IP ranges uploaded. |
72 |
%1$s action with source value: %2$s and action: %3$s has been added. |
73 |
%1$s action with source value: %2$s and action: %3$s has been removed. |
74 |
%1$s action source value: %2$s and action: %3$s has been updated. |
75 |
Default action for %1$s has changed to %2$s. |