MachineUsers (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 users on this machine

Fields¶

Name	Type	Visible	Description
Organization ID	numeric	false	Internal ID that references the Organization entity (Foreign Key)
Organization Guid	guid	false
Organization	string	true	Name of the organization
Organization Description	string	false	Description
Organization Custom Field1	string	false	Available for custom data, not used by OctoSAM Inventory,
Organization Custom Field2	string	false	Available for custom data, not used by OctoSAM Inventory,
Organization Custom Field3	string	false	Available for custom data, not used by OctoSAM Inventory,
Organization Custom Field4	string	false	Available for custom data, not used by OctoSAM Inventory,
Object State ID	numeric	false	Internal ID that references the ObjectState entity (Foreign Key)
Object State	string	false	Object state name
Object State Octopus Id	string	false	Octopus technical name of this state
User ID	numeric	false	Internal ID for the User entity (Primary Key)
User Guid	guid	false	A unique ID that can be used to link to this user object by external applications,
User	string	true	Combination of attributes for consisten naming on screen or in reports
Login Name	string	false	SAMAccount name,
Domain Name	string	false	Domain of the logged on user,
Display Name	string	false	DisplayName attribute from the directory service,
User Description	string	false	Description attribute from the directory service,
Directory Title	string	false	Title (JobTitle) attribute from Active Directory
Directory Employee ID	string	false	EmployeeID attribute from Active Directory (updated on import and housekeeping)
Directory Company	string	false	Directory attribute from Active Directory
Directory Mail	string	false	Mail attribute from Active Directory
Directory Proxy Addresses	string	false	ProxyAddresses attribute from Active Directory
Directory Telephone Number	string	false	TelephoneNumber attribute from Active Directory
Directory Postal Code	string	false	PostalCode attribute from Active Directory
Directory City	string	false	City attribute from Active Directory
Directory Street	string	false	Street attribute from Active Directory
Directory Street Address	string	false	StreetAddress attribute from Active Directory
Directory Department	string	false	Department from Active Directory
Directory Department Number	string	false	DepartmentNumber from Active Drectory
Directory Home Directory	string	false	HomeDirectoy attribute from Active Directory
Directory Home Drive	string	false	HomeDrive attribute from Active Directory
Directory Physical Delivery Office Name	string	false	PhysicalDeliveryOfficeName attribute from Active Directory
User Principal Name	string	true	UserPrincipalName from the directory service,
Printable Name	string	false	Combination of attributes for consisten naming on screen or in reports
Created	date	false	Date/Time this user object was created
First Scan	date	false	Date/Time this user was scanned first
Deleted In Directory	bool	false	True, if the user object was deleted from the directory.
Deleted In Directory First Detected	date	false	Date/Time the DeletedInDirectory flag was set,
Last Found In Directory	date	false	Date/Time the user object was last found in Active Directory,
Last Found In Entra ID	date	false	Date/Time this user was last found in Entra ID
Directory Path	string	false	Path of the user object in the directory service
Directory Container Path	string	false	Path to the container objct of this user
Directory Extension Attribute1	string	false	ExtensionAttribute from Active Directory
Directory Extension Attribute2	string	false	ExtensionAttribute from Active Directory
Directory Extension Attribute3	string	false	ExtensionAttribute from Active Directory
Directory Extension Attribute4	string	false	ExtensionAttribute from Active Directory
Directory Extension Attribute5	string	false	ExtensionAttribute from Active Directory
Directory Extension Attribute6	string	false	ExtensionAttribute from Active Directory
Directory Extension Attribute7	string	false	ExtensionAttribute from Active Directory
Directory Extension Attribute8	string	false	ExtensionAttribute from Active Directory
Directory Extension Attribute9	string	false	ExtensionAttribute from Active Directory
Directory Extension Attribute10	string	false	ExtensionAttribute from Active Directory
Directory Extension Attribute11	string	false	ExtensionAttribute from Active Directory
Directory Extension Attribute12	string	false	ExtensionAttribute from Active Directory
Directory Extension Attribute13	string	false	ExtensionAttribute from Active Directory
Directory Extension Attribute14	string	false	ExtensionAttribute from Active Directory
Directory Extension Attribute15	string	false	ExtensionAttribute from Active Directory
Directory Last Logon Timestamp	date	false	LastLogonTimestamp attribute from Active Directory (updated on import and housekeeping). Resolution: 14 days.
Directory Preferred Language	string	false	User's preferred language from ActiveDirectory
Directory When Created	date	false	WhenCreated attribute from Active Directory
Directory When Changed	date	false	WhenChanged attribute from Active Directory (updated on import and housekeeping)
Directory User Account Control	numeric	false	UserAccountControl attribute from Active Directory (updated on import and housekeeping)
Directory Disabled	bool	false	True if the UserAccountControl attribute has the disable bit set
Directory Type	string	false	Directory type that this user was found in.,
Mapping Tag	string	false	A field that can be used for custom organization mapping
Last Scan	date	true	Date/Time this entity got scanned last
Last Scan Guid	guid	false
Current Date Time	date	false	Date and time the query was run. For reference if you use and save query results.

Query information¶

Property	Value	Description
Query Guid	31744e3c-526b-4572-9abc-b9b96f91ff9a	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