biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / General / Users / User Access Log
API Users / User Action Record
USR5 - User Access Log Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
UserCode KEY UNIQUEUser CodenVarChar
8OUSR
Users
PRIMARYYes
ActionPerformed ActionVarChar
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
1
ActionByUser Who Performed the ActionnVarChar
8
ClientIPIP Address of Client ComputernVarChar
127
DateDateDate
8
TimeTimeInt
11
0
ClientNameHostname of Client ComputernVarChar
32
ProcessIDProcess ID of B1 ApplicationInt
11
-1
SessionIDConnection Session IDInt
11
-1
ReasonIDReason IDInt
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
11
ReasonDescReason DescriptionnVarChar
127
WinSessnIDClient Windows Session IDInt
11
-1
WinUsrNameUser Name of Windows UsernVarChar
100
ProcNameProcess Name of Logged-On App.nVarChar
80

SELECT statement

SELECT USR5.UserCode AS 'User Code', USR5.Action AS 'Performed Action', USR5.ActionBy AS 'User Who Performed the Action', USR5.ClientIP AS 'IP Address of Client Computer', USR5.Date AS 'Date', USR5.Time AS 'Time', USR5.ClientName AS 'Hostname of Client Computer', USR5.ProcessID AS 'Process ID of B1 Application', USR5.SessionID AS 'Connection Session ID', USR5.ReasonID AS 'Reason ID', USR5.ReasonDesc AS 'Reason Description', USR5.WinSessnID AS 'Client Windows Session ID', USR5.WinUsrName AS 'User Name of Windows User', USR5.ProcName AS 'Process Name of Logged-On App.' FROM USR5 AS USR5

Related information


User Action Record UserActionRecord Object· Table: USR5
Displays the access details and the actions of SAP Business One users who have logged on and logged off with the SAP Business One client or the DI API. Source table: USR5.
   Parent: Users Users Object· Table: OUSR
Users OUSR SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates