Skip to content

UalUserAccess

Holds Microsoft User Access Log user access data.

Fields

Field Type Description
ActivityCount bigint The number of times a particular user accessed a role or service
FirstSeen datetime2 The date and time when a user first accesses a role or service
ID bigint Internal ID for the UalUserAccess entity (Primary Key)
LastSeen datetime2 The date and time when a user last accessed a role or service
MachineID bigint Internal ID that references the Machine entity (Foreign Key)
TenantIdentifier nvarchar A unique GUID for a tenant client of an installed role or product that accompanies the UAL data, if applicable.
UalRoleID bigint Internal ID that references the UalRole entity (Foreign Key)
UserID bigint Internal ID that references the User entity (Foreign Key)
UserName nvarchar The user name on the client that accompanies the UAL entries from installed roles and products, if applicable.