USR5 - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL Administration / Users / User Access Log

DTW Administration / Setup / General / Users / User Access Log

API Users / User Action Record

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
UserCode ^KEY ^UNIQUE	User Code	nVarChar		8	OUSR Users		PRIMARY	Yes
Action	Performed Action	VarChar	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
ActionBy	User Who Performed the Action	nVarChar		8
ClientIP	IP Address of Client Computer	nVarChar		127
Date	Date	Date		8
Time	Time	Int		11		0
ClientName	Hostname of Client Computer	nVarChar		32
ProcessID	Process ID of B1 Application	Int		11		-1
SessionID	Connection Session ID	Int		11		-1
ReasonID	Reason ID	Int	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
ReasonDesc	Reason Description	nVarChar		127
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

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

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
OUSR SQL Table

biuan SAP® BUSINESS ONE

Object
Users

Object
UserActionRecord

Enumeration

UserActionTypeEnum

Method

SetCurrentLine

Property

Action

Count

UserCode

UserFields

WindowsSession

WindowsUser

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