UalAccessedServers (System User Context)

OctoSAM System Query

This query is an integral part of the OctoSAM application. OctoSAM starts the query to display tabular data within the application. The query can only be started from within the intended application system context.

Show Microsoft UAL server access information for this machine.

Fields

Name	Type	Visible	Description
ID	numeric	false	Internal ID for the UalDeviceAccess entity (Primary Key)
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
Machine	string	true	Distinct machine name. Use Column Chooser to show partial values such as Name or Domain of machines
Operating System	string	true	Operating System installed on this machine as reported by OctoSAM scanners
Organization ID	numeric	false	Internal ID that references the Organization entity (Foreign Key)
Organization	string	true	Name of the organization this entity is mapped to
Product Name	string	true	Microsoft User Access Logging product name
Role Name	string	true	Microsoft User Access Logging role name
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
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

• UalDeviceAccess

• UalRole

• Machine

Query information

Property	Value	Description
Query Guid	2d87ba1b-2d8b-4a9e-93ce-bc6419405d8c	The internal id of the query. Must be unique
SupportsDesktop	true	If true, the query can be started from the OctoSAM Windows GUI
SupportsWeb	false	If true, the query can be started from the OctoSAM Web UI