UalUserAccess (System Machine 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.

List Microsoft UAL user access information for this machine.

Fields¶

Name	Type	Visible	Description
Product Name	string	true	Microsoft User Access Logging product name
Role Name	string	true	Microsoft User Access Logging role name
User Name	string	true	The user name on the client that accompanies the UAL entries from installed roles and products, if applicable.
User	string	true	Distinct user name. Use Column Chooser to show partial values such as Login Name, Domain or Display Name of users
Login Name	string	false	User's login name
Domain Name	string	false	Windows NETBIOS Domain Name
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)
First Seen	date	true	The date and time when a user first accesses a role or service
Last Seen	date	true	The date and time when a user last accessed a role or service
Activity Count	numeric	true	The number of times a particular user accessed a role or service
User ID	numeric	false	Internal ID that references the User entity (Foreign Key)
User Guid	guid	false	OctoSAM Inventory internal Guid of the user entity
User Principal Name	string	false
Description	string	false	Description attribute of the directory service or manually entered during offline scan
Directory Path	string	false	Path where the machine was found in the directory service. Usually an LDAP path.
Directory Container Path	string	false	Path to the container of this object. Provided for grouping or export to other applications.
Directory Disabled	bool	false	True if the UserAccountControl attribute has the disable bit set
Directory Employee ID	string	false
Directory Department Number	string	false
Directory Department	string	false
First Scan	date	false	Date/Time of first scan of this machine
Last Scan	date	false	Date/Time of the last imported scan for this machine as reported by the machine (may be out of sync)
Directory Company	string	false
Directory Last Logon Timestamp	date	false	LastLogonTimestamp attribute from Active Directory (updated on import and on housekeeping). Resolution: 14days.
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¶

Query information¶

Property	Value	Description
Query Guid	c90010d0-8a26-4509-83dc-07da122551aa	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