Device access overview

License restriction

This query requires the UAL license option.

List device access per device, server and role.

Fields

Name	Type	Visible	Description
Organization	string	true	Name of the organization this entity is mapped to
Organization ID	numeric	false	Internal ID that references the Organization entity (Foreign Key)
Machine	string	true	Distinct machine name. Use Column Chooser to show partial values such as Name or Domain of machines
Machine ID	numeric	false	Internal ID that references the Machine entity (Foreign Key)
Machine Guid	guid	false	A unique ID that can be used to link to this machine object by external applications
Domain Name	string	false	Windows NETBIOS Domain Name
Machine Name	string	false	Machine name (computer name)
Virtual Machine	bool	false	True if this is a virtual machine
Operating System	string	false	Full name of the OS
Operating System Version	string	false	Additional version information about the OS
Operating System Build	string	false	Build number of the OS
Operating System Server	bool	false	True if this OS is a server version
Raw Manufacturer	string	false	Manufacturer of the machine as defined in WMI
Manufacturer	string	false	Normalized manufacturer information. See field 'Raw Manufacturer' for scanned information
Model	string	false	Model of the Machine as defined in WMI
Last Ual Scan	date	false	Time of the last imported User Access Logging scan on this machine. Null for machines that don't support UAL.
Last Ual Scan GUID	guid	false	GUID of the last imported User Access Logging scan on this machine. Null for machines that don't support UAL.
IP Address	string	true	Microsoft UAL Device Access IP address
Client Machine ID	numeric	false	OctoSAM Inventory internal ID of the client machine
Product Name	string	true	Microsoft User Access Logging product name
Role Name	string	true	Microsoft User Access Logging role name
Role G Uid	guid	false	Microsoft User Access Logging role GUID
First Seen	date	true	The date and time when an IP address was first used to access a role or service
Last Seen	date	true	The date and time when an IP address was last used to access a role or service
Activity Count	numeric	true	The number of times a particular device accessed the role or service
Client Organization	string	true	Client's organization if the client is knwon to OctoSAM Inventory
Client Organization ID	numeric	false	Client's organization OctoSAM internal ID
Client Machine Guid	guid	false	Client machine object Guid if knwon to OctoSAM Inventory
Client Machine	string	true	Client machine object if known to OctoSAM Inventory
Client Domain Name	string	false	Client's domain name
Client Machine Name	string	false	Client machine name if known to OctoSAM Inventory
Client Virtual Machine	bool	false	True if client is a virtual machine
Client Operating System	string	false	Client's operating system
Client Operating System Version	string	false	Client's operating system version
Client Operating System Build	string	false	Client's operating system build
Client Operating System Server	bool	false	True if client's operating system is a server variant
Client Raw Manufacturer	string	false	Manufacturer of the client machine as reported by UAL
Client Manufacturer	string	false	Normalized manufacturer of the client machine
Client Model	string	false	Client machine model
Current Date Time	date	false	Date and time the query was run. For reference if you use and save query results.

Main entities referenced from this query

• Machine

• UalDeviceAccess

• UalRole

Query information

Property	Value	Description
Query Guid	191de129-8f93-4b1f-80d1-8f15f0210b69	The internal id of the query. Must be unique
SupportsDesktop	true	If true, the query can be started from the OctoSAM Windows GUI
SupportsWeb	true	If true, the query can be started from the OctoSAM Web UI