Scanned and not scanned machines combined

Combined list of machines from scans and unscanned machines from active directory.

LastLogonTimestamp resolution

The LastLogonTimestamp attribute is replicated across domain controllers, but it has a resolution of approximately 14 days. This means that if a user logs on to a computer, the LastLogonTimestamp may not be updated immediately. As a result, the LastLogonTimestamp may not accurately reflect the user's last logon time.

Fields

Name	Type	Visible	Description
Missing Machine ID	numeric	false	OctoSAM internal ID of this MissingMachine entity
Entra Id Missing Device ID	numeric	false
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
Source	string	true	Source from where this computer object was read. Refers to import service configuration.
Name	string	false	Machine name
Domain Name	string	false	NETBIOS domain name as specified in the import service configuration
Machine	string	true	Distinct machine name. Use Column Chooser to show partial values such as Name or Domain of machines
Description	string	false	Description attribute from Active Directory
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
Raw Manufacturer	string	false	Manufacturer of the machine as defined in WMI
Manufacturer ID	numeric	false	Internal ID that references the Manufacturer entity (Foreign Key)
Manufacturer	string	false	Normalized manufacturer information. See field 'Raw Manufacturer' for scanned information
Model	string	true	Model of the Machine as defined in WMI
Processor	string	false	Processor Name as reported by WMI
Last Scan	date	true	Date/Time this entity got scanned last
Operating System Family	string	true	A short identifier of the operating system family
Operating System	string	true	Operating System installed on this machine as reported by OctoSAM scanners
Operating System Version	string	false	OperatingSystemVersion attribute from Active Directory
Operating System Server	bool	true	True if a server operating system was detected
Path	string	false	Distinguished name of this machine in Active Directory
Container Path	string	true	Distinguished name of the container of this machine. Provided for grouping and export
Custom Field1	string	false	Available for custom data, not used by OctoSAM Inventory.
Custom Field2	string	false	Available for custom data, not used by OctoSAM Inventory.
Custom Field3	string	false	Available for custom data, not used by OctoSAM Inventory.
Custom Field4	string	false	Available for custom data, not used by OctoSAM Inventory.
Ext1	string	false	Site specific data, can optionally be used to load site-specific extended schema properties.
Ext2	string	false	Site specific data, can optionally be used to load site-specific extended schema properties.
Ext3	string	false	Site specific data, can optionally be used to load site-specific extended schema properties.
Ext4	string	false	Site specific data, can optionally be used to load site-specific extended schema properties.
Extension Attribute1	string	false	From Active Directory
Extension Attribute2	string	false	From Active Directory
Extension Attribute3	string	false	From Active Directory
Extension Attribute4	string	false	From Active Directory
Extension Attribute5	string	false	From Active Directory
Extension Attribute6	string	false	From Active Directory
Extension Attribute7	string	false	From Active Directory
Extension Attribute8	string	false	From Active Directory
Extension Attribute9	string	false	From Active Directory
Extension Attribute10	string	false	From Active Directory
Extension Attribute11	string	false	From Active Directory
Extension Attribute12	string	false	From Active Directory
Extension Attribute13	string	false	From Active Directory
Extension Attribute14	string	false	From Active Directory
Extension Attribute15	string	false	From Active Directory
Last Logon Timestamp	date	true	Date/Time this account last logged on to Active Directory. This value is not instantly replicated and may not be exact. Resolution is configurable, usually about 14 days.
When Created	date	false	From Active Directory
When Changed	date	false	From Active Directory
User Account Control	numeric	false	UserAccountControl attribute from Active Directory
Disabled	bool	true	True if UserAccountControl has the computer account disabled flag set
No Scan	bool	true	If true this machine should not be scanned. It is ignored for scan coverage reporting.
Most Frequent User ID	numeric	false	Internal ID that references the User entity (Foreign Key)
Most Frequent User Guid	guid	false	OctoSAM internal Guid of the user that is most frequently using this machine
Most Frequent User Organization ID	numeric	true
Most Frequent User	string	false	User that is most frequently using this machine
Most Frequent User Display Name	string	false
Most Frequent User Login Name	string	false
Most Frequent User Domain Name	string	false
Most Frequent User Principal Name	string	false
Most Frequent User Mail	string	false
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

• DirectoryMissingMachine

• Machine

Query information

Property	Value	Description
Query Guid	9986d127-d9af-4cf9-9017-66c1b66953b6	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