Skip Headers
Oracle® Real User Experience Insight User's Guide
12c Release 2 (12.1.0.3) for Linux x86-64

Part Number E37266-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

V Analyzing User Events

This appendix describes how you can analyze user events. The structure of the database table used by it is also explained.

V.1 Introduction

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.

V.2 Controlling the Availability of User Event Information

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:

  1. Logon to the Reporter system, and issue the following command as the root user:

    # su - moniforce
    # sqlplus /@uxinsight
    
  2. 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).

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

V.3 User Event Table Structure

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 V-1, contains user event information.

Table V-1 UXS_EVENTS Table

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.


Event Codes and Descriptions

The possible CODE events and their associated descriptions are shown in Table V-2.

Table V-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.