| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| UserCode |
User Code |
nVarChar |
25 |
OUSR |
|
|
|
| Action |
Performed Action |
VarChar |
1 |
- |
|
I |
Logon Succeeded |
| |
|
|
|
|
|
F |
Logon Failed |
| |
|
|
|
|
|
O |
Logoff |
| |
|
|
|
|
|
C |
Created |
| |
|
|
|
|
|
S |
Superuser Selected |
| |
|
|
|
|
|
D |
Superuser Deselected |
| |
|
|
|
|
|
L |
Locked |
| |
|
|
|
|
|
U |
Unlocked |
| |
|
|
|
|
|
P |
Password Changed |
| |
|
|
|
|
|
N |
Screen Unlock Failed |
| |
|
|
|
|
|
T |
Temporary User Change |
| |
|
|
|
|
|
R |
Removed |
| ActionBy |
User Who Performed the Action |
nVarChar |
25 |
- |
|
|
|
| ClientIP |
IP Address of Client Computer |
nVarChar |
200 |
- |
|
|
|
| Date |
Date |
Date |
8 |
- |
|
|
|
| Time |
Time |
Int |
11 |
- |
0 |
|
|
| ClientName |
Hostname of Client Computer |
nVarChar |
200 |
- |
|
|
|
| ProcessID |
Process ID of B1 Application |
Int |
11 |
- |
-1 |
|
|
| SessionID |
Connection Session ID |
Int |
11 |
- |
-1 |
|
|
| ReasonID |
Reason ID |
Int |
11 |
- |
|
1 |
Planned: Initial System Configuration |
| |
|
|
|
|
|
2 |
Planned: System Configuration Change |
| |
|
|
|
|
|
3 |
Planned: System Maintenance |
| |
|
|
|
|
|
4 |
Planned: Knowledge Transfer to End-User |
| |
|
|
|
|
|
11 |
Unplanned: Root Cause Analysis |
| |
|
|
|
|
|
12 |
Unplanned: Knowledge Transfer to End-User |
| |
|
|
|
|
|
13 |
Unplanned: System Maintenance |
| |
|
|
|
|
|
14 |
Unplanned: System Configuration Change |
| |
|
|
|
|
|
51 |
System Maintenance |
| |
|
|
|
|
|
52 |
Root Cause Analysis |
| |
|
|
|
|
|
53 |
Consulting / Support |
| |
|
|
|
|
|
54 |
Other |
| ReasonDesc |
Reason Description |
nVarChar |
250 |
- |
|
|
|
| WinSessnID |
Client Windows Session ID |
Int |
11 |
- |
-1 |
|
|
| WinUsrName |
User Name of Windows User |
nVarChar |
100 |
- |
|
|
|
| ProcName |
Process Name of Logged-On App. |
nVarChar |
80 |
- |
|
|
|
| AliveDurtn |
Time Logged-On User Keep Alive |
Int |
11 |
- |
0 |
|
|
| LogoutTime |
User Logout Time |
Int |
11 |
- |
|
|
|
| Source |
Login Terminal |
nVarChar |
100 |
- |
|
|
|
| UserID |
User ID |
Int |
6 |
- |
|
|
|