UalDeviceAccess

Microsoft User Access Log device access data.

Fields

Field	Type	Description
ActivityCount	bigint	The number of times a particular device accessed the role or service
ClientFQDN	nvarchar	Hostname of the client through DNS reverse lookup or OctoSAM Inventory lookup
ClientMachineID	bigint	Internal ID that references the Machine entity (Foreign Key)
FirstSeen	datetime2	The date and time when an IP address was first used to access a role or service
ID	bigint	Internal ID for the UalDeviceAccess entity (Primary Key)
IPAddress	nvarchar	Microsoft UAL Device Access IP address
LastSeen	datetime2	The date and time when an IP address was last used to access a role or service
MachineID	bigint	Internal ID that references the Machine entity (Foreign Key)
UalRoleID	bigint	Internal ID that references the UalRole entity (Foreign Key)