UalUserAccess
Holds Microsoft User Access Log user access data.
erDiagram
Machine ||--o{ UalUserAccess : "MachineID"
UalRole ||--o{ UalUserAccess : "UalRoleID"
User ||--o{ UalUserAccess : "UserID"
Fields
| Field |
Type |
Description |
| ActivityCount |
numeric |
The number of times a particular user accessed a role or service |
| FirstSeen |
datetime |
The date and time when a user first accesses a role or service |
| ID |
numeric |
Internal ID for the UalUserAccess entity (Primary Key) |
| LastSeen |
datetime |
The date and time when a user last accessed a role or service |
| MachineID |
numeric |
Internal ID that references the Machine entity (Foreign Key) |
| TenantIdentifier |
string |
A unique GUID for a tenant client of an installed role or product that accompanies the UAL data, if applicable. |
| UalRoleID |
numeric |
Internal ID that references the UalRole entity (Foreign Key) |
| UserID |
numeric |
Internal ID that references the User entity (Foreign Key) |
| UserName |
string |
The user name on the client that accompanies the UAL entries from installed roles and products, if applicable. |
References
| Column Name |
Referenced Table |
Description |
| MachineID |
Machine |
Basic machine information. A machine is a physical or virtual device that can be scanned by OctoSAM Inventory. A machine can also be a mobile device such as a phone or tablet. |
| UalRoleID |
UalRole |
Holds Microsoft User Access Log application/role names and GUIDs |
| UserID |
User |
Basic user Information |