UserMachines (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.

List user to machine relations.

Fields

Name	Type	Visible	Description
Organization ID	numeric	false	Internal ID that references the Organization entity (Foreign Key)
Organization	string	true	Name of the organization
Organization Description	string	false	Description
Machine ID	numeric	false	Internal ID for the Machine entity (Primary Key)
Machine Guid	guid	false	A unique ID that can be used to link to this machine object by external applications
Machine	string	true	Use this name in reports for consistency and to avoid having to build the printable name from its parts
Machine Name	string	false	Machine name (computer name)
Domain Name	string	false	Windows NETBIOS Domain Name
Fully Qualified Domain Name	string	false	Fully qualified domain name as seen by the scanner through reverse lookup of the network address
Manufacturer ID	numeric	false	Internal ID that references the Manufacturer entity (Foreign Key)
Manufacturer	string	false	Normalized hardware manufacturer name
Raw Manufacturer	string	false	Manufacturer string as scanned from the system. See field 'Manufacturer' for normalized manufacturer
Model	string	true
Processor	string	false
Physical Memory	numeric	false
Chassis Types	string	false
Bios Serial Number	string	false
Bios Name	string	false
Bios Version	string	false
Bios Sm Bios Version	string	false
Bios Sm Bios Uuid	guid	false
Bios Asset Tag	string	false	A site specific tag that can be stored in the BIOS of the machine
Operating System	string	true	Full name of the OS
Deleted In Directory	bool	false
Deleted In Directory First Detected	date	false
Last Scan	date	true	Date/Time of the last imported scan for this machine as reported by the machine (may be out of sync)
Last Scan GUID	guid	false	Global Unique IDentifier of the last scan
Local Administrator	bool	false	True if the user had local administrator rights at the time of the scan
Last Found In Directory	date	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	29c36dd4-9a49-4e9f-8d55-ba309fd7132e	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