All machines with last scanner build info (Internal)

OctoSAM internal query

Internal queries are advanced queries for analysis of the inner workings of the OctoSAM application. These queries are geared towards administrators with an in-depth knowledge of OctoSAM.

All machines with last scanner version if available.

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
Environment ID	numeric	false	Internal ID that references the Environment entity (Foreign Key)
Environment	string	false	Name of the Environment
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
Machine Guid	guid	false	A unique ID that can be used to link to this machine object by external applications
Machine ID	numeric	false	Internal ID for the Machine entity (Primary Key)
Machine Name	string	false	Machine name (computer name)
Machine	string	true	Use this name in reports for consistency and to avoid having to build the printable name from its parts
Alternate Name	string	false	Contains the computer name for systems that may have different host and computer names, such as macOS
Fully Qualified Domain Name	string	false	Fully qualified domain name as seen by the scanner through reverse lookup of the network address
Machine Description	string	false	Description attribute of the directory service or manually entered during offline scan
Alternate Description	string	false	Alternate description field specific to the scanned machine type. For example locally entered description in macOS.
Domain Name	string	false	Windows NETBIOS Domain Name
Site	string	false	Active Directory Site that the machine belongs to
Location	string	false	Active Directory location attribute
Directory Ext1	string	false	Site specific data, can optionally be used to load site-specific extended schema properties
Directory Ext2	string	false	Site specific data, can optionally be used to load site-specific extended schema properties
Directory Ext3	string	false	Site specific data, can optionally be used to load site-specific extended schema properties
Directory Ext4	string	false	Site specific data, can optionally be used to load site-specific extended schema properties
Network Address	string	false	Network address, usually the IP number
Network Mac Address	string	false	MAC address of the main interface (corresponds to NetworkNetworkAddress
Network Subnet Mask	string	false	Subnet mask if network address is an ip number
Network Network Address	string	false	Network address calculated from NetworkAddress and NetworkSubnetkMask fields
Network Network Name	string	false	Network name can be set from an external source. Not used by OctoSAM.
Network Network CIDR	string	false	Network in CIDR notation
Network Default Gateway	string	false	Network default gateway
Network DHCP	bool	false	True if DHCP is enabled on the main interface of the machine
Network DNS	string	false	Addresses of configured DNS servers
Sid	string	false	Computer SID
Operating System	string	true	Full name of the OS
Operating System Publisher	string	false	Publisher of the OS.
Operating System Family	string	true	A short name to identify different operating system families
Operating System Server	bool	false	True if this OS is a server version
Operating System Version	string	false	Additional version information about the OS
Operating System Display Version	string	false	DisplayVersion for operating systems that support this attribute. Newer Windows versions use this instead of ReleaseID.
Operating System Csd Version	string	false	CSDVersion field for Windows systems. This file may be interpreted by partner systems such as Flexera One.
Operating System Release	string	false	An OS specific release marker. For Windows 10 contains the 'Version'.
Operating System Build	string	false	Build number of the OS
Operating System Last Boot Up Time	date	false	DateTime the operating system last booted
Operating System Update Build Revision	numeric	false	Windows UBR number
Operating System Install Date	date	false	Date/Time this OS instance was installed (as reported by WMI)
Operating System Language	string	false	Language of the operating system as reported by WMI in cleartext
Operating System Edition	string	false	An OS specific edition marker
Operating System Product Info	numeric	false	For Windows, contains the result of the GetProductInfo() system call.
Operating System Bits	numeric	false	32 or 64 bit
Created	date	false	Time this object was created
Last Scan Guid	guid	false	GUID of the last imported .scan file for this entity.
First Scan	date	false	Date/Time of first scan of this machine
Last Found In Entra Id	date	false	Date/Time this device was last found in Entra ID
Last Found In Directory	date	false	Time the object was last found in the directory service
Deleted In Directory	bool	false	True, if directory check detects that the machine is no longer found in directory
Deleted In Directory First Detected	date	false	Date/Time the delete flag was set
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.
Entra Id Tenant Id	guid	false	Entra ID tenant id for machines that are Entra ID joined
Entra Id Id	string	false	ID from Entra ID
Entra Id Device Id	string	false	Device ID from Entra ID
Entra Id Device Ownership	string	false	DeviceOwnership field from Entra ID
Entra Id Enrollment Profilename	string	false	EnrollmentProfileName field from Entra ID
Entra Id On Premises Sync Enabled	bool	false	True if on premises sync is enabled for this machine in Entra ID
Entra Id On Premises Last Sync Date Time	date	false	OnPremisesLastSyncDateTime field from Entra ID
Entra Id Approximate Last Sign In Date Time	date	false	ApproximateLastSignInDateTime field Entra ID
Entra Id Trust Type	string	false	TrustType field from Entra ID
Entra Id Profile Type	string	false	ProfileType field from Entra ID
Entra Id Registration Date Time	date	false	RegistrationDateTime field from Entra ID
Entra Id Is Managed	bool	false	True if this machine is managed by Entra ID MDM policies
Entra Id Is Compliant	bool	false	True if this machine is deemed compliant to Entra ID MDM policies
Entra Id Extension Attribute1	string	false	Extension attribute 1 from Entra ID
Entra Id Extension Attribute2	string	false	Extension attribute 2 from Entra ID
Entra Id Extension Attribute3	string	false	Extension attribute 3 from Entra ID
Entra Id Extension Attribute4	string	false	Extension attribute 4 from Entra ID
Entra Id Extension Attribute5	string	false	Extension attribute 5 from Entra ID
Entra Id Extension Attribute6	string	false	Extension attribute 6 from Entra ID
Entra Id Extension Attribute7	string	false	Extension attribute 7 from Entra ID
Entra Id Extension Attribute8	string	false	Extension attribute 8 from Entra ID
Entra Id Extension Attribute9	string	false	Extension attribute 9 from Entra ID
Entra Id Extension Attribute10	string	false	Extension attribute 10 from Entra ID
Entra Id Extension Attribute11	string	false	Extension attribute 11 from Entra ID
Entra Id Extension Attribute12	string	false	Extension attribute 12 from Entra ID
Entra Id Extension Attribute13	string	false	Extension attribute 13 from Entra ID
Entra Id Extension Attribute14	string	false	Extension attribute 14 from Entra ID
Entra Id Extension Attribute15	string	false	Extension attribute 15 from Entra ID
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 of the machine as defined in WMI
Model	string	true	Model of the Machine as defined in WMI
Bios Serial Number	string	false	BIOS Serial Number as reported by WMI
Bios Smbios Uuid	guid	false	SMBIOS UUID of the machine
Bios Asset Tag	string	false	BIOS asset tag if supported
Bios Name	string	false	BIOS Name as reported by WMI
Bios Version	string	false	BIOS Version as reported by WMI
Bios Sm Bios Version	string	false	SMBIOS Version as reported by WMI
Processor	string	false	Processor Name as reported by WMI
Processor Speed	numeric	false	Max speed of the processor in MHz
Processor Manufacturer ID	numeric	false	Internal ID that references the Manufacturer entity (Foreign Key)
Processor Manufacturer	string	false	Normalized hardware manufacturer name
Number Of Processors	numeric	false	Number of processors as reported by WMI
Number Of Cores	numeric	false	Number of cores as reported by WMI
Number Of Logical Processors	numeric	false	Number of logical processors as reported by WMI
Oracle Core Factor	object	false	Oracle Core Factor to use for Oracle pricing. Queries should always use this field.
Physical Memory	numeric	false	Amount of physical memory in the system as reported by WMI
Chassis Types	string	false	ChassisTypes as reported in WMI in cleartext
Directory Last Logon Timestamp	date	false	LastLogonTimestamp attribute from Active Directory (updated on import and on housekeeping). Resolution: 14days.
Directory Last Logon Last Scan Diff	numeric	false
Directory When Created	date	false	WhenCreated attribute from Active Directory
Directory When Changed	date	false	WhenChanged attribute from Active Directory (updated on import and on housekeeping)
Directory User Account Control	numeric	false	UserAccountControl attribute from Active Directory (updated on import and on housekeeping)
Directory Disabled	bool	false	True if the UserAccountControl attribute has the disable bit set
Most Frequent User ID	numeric	false	Internal ID that references the User entity (Foreign Key)
Most Frequent User	string	true	Combination of attributes for consistent naming on screen or in reports
Most Frequent User Guid	guid	false	A unique ID that can be used to link to this user object by external applications
Most Frequent User Organization ID	numeric	false	Internal ID that references the Organization entity (Foreign Key)
Most Frequent User Principal Name	string	false	UserPrincipalName from the directory service
Most Frequent User Mail	string	false	Mail attribute from Active Directory
Most Frequent User Domain Name	string	false	Domain of the logged on user
Most Frequent User Login Name	string	false	Access
Most Frequent User Last Scan	date	false	Date/Time of last scan that updated this relation
Most Frequent User Local Administrator	bool	false	True if the referenced user is member of the referenced machine's Administrators group
Most Frequent User Last Login Was Remote	bool	false	True if scan was during a remote session
Last User ID	numeric	false	Internal ID that references the User entity (Foreign Key)
Last User	string	false	Combination of attributes for consistent naming on screen or in reports
Last User Guid	guid	false	A unique ID that can be used to link to this user object by external applications
Last User Organization ID	numeric	false	Internal ID that references the Organization entity (Foreign Key)
Last User Last Scan	date	false	Date/Time of last scan that updated this relation
Last User Local Administrator	bool	false	True if the referenced user is member of the referenced machine's Administrators group
Last User Login Was Remote	bool	false	True if scan was during a remote session
Custom Field1	string	false	Available for custom data for this machine, not used by OctoSAM Inventory
Custom Field2	string	false	Available for custom data for this machine, not used by OctoSAM Inventory
Custom Field3	string	false	Available for custom data for this Machine, not used by OctoSAM Inventory
Custom Field4	string	false	Available for custom data for this Machine, not used by OctoSAM Inventory
Res1	string	false	Reserved for future use
Res2	string	false	Reserved for internal use by future versions
Res3	string	false	Reserved for future use
Res4	string	false	Reserved for future use
Notes	string	false	Available for custom notes about this entity
Virtual Machine	bool	true	True if this is a virtual machine
Virtualization Host	bool	false	True if this machine hosts virtual machines
Mapping Tag	string	false	This field can be used for custom mapping logic
Last Scanner Tag	string	false	Command-line tag that was specified on the last scan of this machine
Service Now Sys ID	guid	false	ServiceNow: sys_id of the replicated object
Service Now Target Class	string	false	ServiceNow: target class of the replicated object
Service Now Last Export	date	false	Date/Time of last export to ServiceNow
Service Now Last Import	date	false	Date/time of last import from ServiceNow
Synch Last Synch	date	false	Date/Time of last synchronization of this machine with the partner CMDB. Not used by OctoSAM Inventory
Synch Token ID	string	false	Can be used for synchronization with another inventory or CMDB system. Holds the key to the identical item in the CMDB. Not used by OctoSAM Inventory
Service Now Install Status	string	false	Install_status of the computer replicated from ServiceNow
Service Now Operational Status	string	false	Operation_status of the computer replicated from ServiceNow
Service Now Support Group	string	false	Support_group of the computer object in ServiceNow
Service Now Life Cycle Stage	string	false
Service Now Life Cycle Stage Status	string	false
Service Now Last Discovered	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 Scanner Build Info	string	true
Virtual Machine Name	string	false	Name of the virtual machine
Virtual Cores	numeric	false	Virtual cores or virtual processors that the hypervisor provides
Guest Tools Version	string	false	Version of installed VMware guest tools
Guest Tools Current	bool	false	True if guest tools were current at scan time
Virtual Machine Last Scan	date	false	Date/Time this VM was last scanned
Virtualization Management System	string	false	Name of the virtualization management system of this machine or host
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

• Machine

• VirtualMachine

Query information

Property	Value	Description
Query Guid	be101461-8839-4a1c-99fb-51037ab3f04c	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