Skip to content

UalDeviceAccess

Microsoft User Access Log device access data.

erDiagram
    Machine ||--o{ UalDeviceAccess : "ClientMachineID"
    Machine ||--o{ UalDeviceAccess : "MachineID"
    UalRole ||--o{ UalDeviceAccess : "UalRoleID"

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 Date/Time when the last DNS lookup for the IP address was performed
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)

References

Column Name Referenced Table Description
ClientMachineID 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.
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