UalDeviceAccess

Microsoft User Access Log device access data.

Fields

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