Skip to content

Machine

Basic machine information. A machine is a physical or virtual device that can be scanned by OctoSAM Inventory. A machine can also be a mobile device such as a phone or tablet.

Fields

Field Type Description
Active bit If true, do not count this machine for installations
AlternateDescription nvarchar Alternate description field specific to the scanned machine type. For example locally entered description in macOS.
AlternateName nvarchar Contains the computer name for systems that may have different host and computer names, such as macOS.
AnalysisExtras xml Holds additional analysis data
BiosAssetTag nvarchar BIOS asset tag if supported
BiosName nvarchar BIOS Name as reported by WMI
BiosSerialNumber nvarchar BIOS Serial Number as reported by WMI
BiosSmBiosUuid uniqueidentifier SMBIOS UUID of the machine
BiosSmBiosVersion nvarchar SMBIOS Version as reported by WMI
BiosVersion nvarchar BIOS Version as reported by WMI
ChassisTypes nvarchar ChassisTypes as reported in WMI in cleartext
CloudProviderAccountID bigint Internal ID that references the CloudProviderAccount entity (Foreign Key)
CostCenter nvarchar Cost center - typically replicated from another system
CostCenterID bigint Internal ID that references the CostCenter entity (Foreign Key)
Created datetime2 Time this object was created
CreatedGUID uniqueidentifier Scan GUID that created this machine
CustomField1 nvarchar Available for custom data for this machine, not used by OctoSAM Inventory.
CustomField2 nvarchar Available for custom data for this machine, not used by OctoSAM Inventory.
CustomField3 nvarchar Available for custom data for this Machine, not used by OctoSAM Inventory
CustomField4 nvarchar Available for custom data for this Machine, not used by OctoSAM Inventory
DeletedInDirectory bit True, if directory check detects that the machine is no longer found in directory.
DeletedInDirectoryFirstDetected datetime2 Date/Time the delete flag was set
Description nvarchar Description attribute of the directory service or manually entered during offline scan
DirectoryAccountExpires datetime2 accountExpires attribute from ActiveDirectory
DirectoryContainerPath nvarchar Path to the container of this object. Provided for grouping or export to other applications.
DirectoryDisabled bit True if the UserAccountControl attribute has the disable bit set
DirectoryExt1 nvarchar Site specific data, can optionally be used to load site-specific extended schema properties.
DirectoryExt2 nvarchar Site specific data, can optionally be used to load site-specific extended schema properties.
DirectoryExt3 nvarchar Site specific data, can optionally be used to load site-specific extended schema properties.
DirectoryExt4 nvarchar Site specific data, can optionally be used to load site-specific extended schema properties.
DirectoryExtensionAttribute1 nvarchar ExtensionAttribute from Active Directory
DirectoryExtensionAttribute10 nvarchar ExtensionAttribute from Active Directory
DirectoryExtensionAttribute11 nvarchar ExtensionAttribute from Active Directory
DirectoryExtensionAttribute12 nvarchar ExtensionAttribute from Active Directory
DirectoryExtensionAttribute13 nvarchar ExtensionAttribute from Active Directory
DirectoryExtensionAttribute14 nvarchar ExtensionAttribute from Active Directory
DirectoryExtensionAttribute15 nvarchar ExtensionAttribute from Active Directory
DirectoryExtensionAttribute2 nvarchar ExtensionAttribute from Active Directory
DirectoryExtensionAttribute3 nvarchar ExtensionAttribute from Active Directory
DirectoryExtensionAttribute4 nvarchar ExtensionAttribute from Active Directory
DirectoryExtensionAttribute5 nvarchar ExtensionAttribute from Active Directory
DirectoryExtensionAttribute6 nvarchar ExtensionAttribute from Active Directory
DirectoryExtensionAttribute7 nvarchar ExtensionAttribute from Active Directory
DirectoryExtensionAttribute8 nvarchar ExtensionAttribute from Active Directory
DirectoryExtensionAttribute9 nvarchar ExtensionAttribute from Active Directory
DirectoryGUID uniqueidentifier GUID of a machine if joined to active directory and supported by the operating system and scanner
DirectoryLastLogonTimestamp datetime2 LastLogonTimestamp attribute from Active Directory (updated on import and on housekeeping). Resolution: 14days.
DirectoryLocation nvarchar Active Directory location attribute
DirectoryPath nvarchar Path where the machine was found in the directory service. Usually an LDAP path.
DirectorySiteName nvarchar Active Directory Site that the machine belongs to
DirectoryUserAccountControl bigint UserAccountControl attribute from Active Directory (updated on import and on housekeeping)
DirectoryWhenChanged datetime2 WhenChanged attribute from Active Directory (updated on import and on housekeeping)
DirectoryWhenCreated datetime2 WhenCreated attribute from Active Directory
DomainName nvarchar Windows NETBIOS Domain Name
EntraIdApproximateLastSignInDateTime datetime2 ApproximateLastSignInDateTime field Entra ID
EntraIdDeviceId nvarchar Device ID from Entra ID
EntraIdDeviceOwnership nvarchar DeviceOwnership field from Entra ID
EntraIdEnrollmentProfileName nvarchar EnrollmentProfileName field from Entra ID
EntraIdExtensionAttribute1 nvarchar Extension attribute 1 from Entra ID
EntraIdExtensionAttribute10 nvarchar Extension attribute 10 from Entra ID
EntraIdExtensionAttribute11 nvarchar Extension attribute 11 from Entra ID
EntraIdExtensionAttribute12 nvarchar Extension attribute 12 from Entra ID
EntraIdExtensionAttribute13 nvarchar Extension attribute 13 from Entra ID
EntraIdExtensionAttribute14 nvarchar Extension attribute 14 from Entra ID
EntraIdExtensionAttribute15 nvarchar Extension attribute 15 from Entra ID
EntraIdExtensionAttribute2 nvarchar Extension attribute 2 from Entra ID
EntraIdExtensionAttribute3 nvarchar Extension attribute 3 from Entra ID
EntraIdExtensionAttribute4 nvarchar Extension attribute 4 from Entra ID
EntraIdExtensionAttribute5 nvarchar Extension attribute 5 from Entra ID
EntraIdExtensionAttribute6 nvarchar Extension attribute 6 from Entra ID
EntraIdExtensionAttribute7 nvarchar Extension attribute 7 from Entra ID
EntraIdExtensionAttribute8 nvarchar Extension attribute 8 from Entra ID
EntraIdExtensionAttribute9 nvarchar Extension attribute 9 from Entra ID
EntraIdId nvarchar ID from Entra ID
EntraIdIsCompliant bit True if this machine is deemed compliant to Entra ID MDM policies
EntraIdIsManaged bit True if this machine is managed by Entra ID MDM policies 
EntraIdOnPremisesLastSyncDateTime datetime2 OnPremisesLastSyncDateTime field from Entra ID
EntraIdOnPremisesSyncEnabled bit True if on premises sync is enabled for this machine in Entra ID
EntraIdProfileType nvarchar ProfileType field from Entra ID
EntraIdRegistrationDateTime datetime2 RegistrationDateTime field from Entra ID
EntraIdTenantId uniqueidentifier Entra ID tenant id for machines that are Entra ID joined
EntraIdTrustType nvarchar TrustType field from Entra ID
EnvironmentID bigint Internal ID that references the Environment entity (Foreign Key)
ExcludeFromSoftwareInventory bit If True, the machine is excluded from Software Inventory. Signatures imported for this machine are ignored. This can be useful for development machines used for building of installation packages.
ExtraData nvarchar Extra data collected for documentation of this machine
FirstScan datetime2 Date/Time of first scan of this machine
FoundInDirectory bit True if the object could be found in Active Directory at last check
FullyQualifiedDomainName nvarchar Fully qualified domain name as seen by the scanner through reverse lookup of the network address
Guid uniqueidentifier A unique ID that can be used to link to this machine object by external applications
HardwareUniqueID nvarchar Unique hardware ID if supported by the hardware. May not change with operating system re-install for physical systems.
HintHasAccessLog bit True if machine has UAL data available
HintHasAutoStart bit True if machine has scanned Windows AutosStart information
HintHasBrowserExtensions bit
HintHasMuiCache bit True if this machine has scanned Windows MUI information
HintHasOfficeAddIns bit True if this machine has registered Microsoft Office add-ins
HintHasSoftwareItems bit True if software items are linked to this machine
HintHasSwidDocuments bit True if machine has scanned SWID documents
HintHasWmi bit True if there is hardware and configuration data (WMI) available for the machine
HintInGroups bit True if the Machine is member in any group
HintIsClusterMember bit True if the machine is member of a custer
HintSoftwarePackageUsageEndDate datetime2 Max consolidated usage date for this Machine
HintSoftwarePackageUsageStartDate datetime2 Min consolidated usage date for this Machine
ID bigint Internal ID for the Machine entity (Primary Key)
ID bigint Internal ID for the Machine entity (Primary Key)
IgnoreForRollout bit Reserved for future use
IgnoreNewSignatures bit If true, do not create new software signatures if only seen on this machine or others that have the IgnoreNewSignatures flag set. Can be set for test and development machines.
ImporterInstance nvarchar Name of the ImporterInstance. Used if you have multiple import module instances writing into the same database.
ImportSourceID bigint ID of the import module that created the entity. 1=OctoscanImportService.
LastBasicHardwareFromWmi datetime2 Date/Time basic hardware info was last calculated from WMI for this machine
LastFoundInDirectory datetime Time the object was last found in the directory service
LastFoundInEntraId datetime2 Date/Time this device was last found in Entra ID
LastHardwareScan datetime2 Time of the last imported WMI scan
LastHardwareScanGUID uniqueidentifier GUID of the last imported WMI scan
LastModification datetime2 Date/Time of last write to this entity
LastModifiedBy nvarchar Windows User ID that last updated this Machine record through the UI
LastScan datetime2 Date/Time of the last imported scan for this machine as reported by the machine (may be out of sync)
LastScanGUID uniqueidentifier GUID of the last imported .scan file for this entity.
LastScannerTag nvarchar Command-line tag that was specified on the last scan of this machine
LastSignatureScan datetime2 Time of the last imported software signature scan for this machine
LastSignatureScanGUID uniqueidentifier GUID of the last imported software signature scan for this machine
LastUalScan datetime2 Time of the last imported User Access Logging scan on this machine. Null for machines that don't support UAL.
LastUalScanGUID uniqueidentifier GUID of the last imported User Access Logging scan on this machine. Null for machines that don't support UAL.
LastUserID bigint Internal ID that references the User entity (Foreign Key)
ManufacturerID bigint Internal ID that references the Manufacturer entity (Foreign Key)
MappingTag nvarchar This field can be used for custom mapping logic
Model nvarchar Model of the Machine as defined in WMI
MostFrequentUserID bigint Internal ID that references the User entity (Foreign Key)
MsftDirectAccessConfigured bit True if Microsoft Direct Access configuration was found at last scan
Name nvarchar Machine name (computer name)
NetworkAddress nvarchar Network address, usually the IP number.
NetworkDefaultGateway nvarchar Network default gateway
NetworkDHCP bit True if DHCP is enabled on the main interface of the machine
NetworkDNS nvarchar Addresses of configured DNS servers
NetworkMacAddress nvarchar MAC address of the main interface (corresponds to NetworkNetworkAddress
NetworkNetworkAddress nvarchar Network address calculated from NetworkAddress and NetworkSubnetkMask fields
NetworkNetworkCIDR nvarchar Network in CIDR notation
NetworkNetworkName nvarchar Network name can be set from an external source. Not used by OctoSAM.
NetworkSubnetMask nvarchar Subnet mask if network address is an ip number
Notes nvarchar Available for custom notes about this entity
NumberOfCores int Number of cores as reported by WMI
NumberOfLogicalProcessors int Number of logical processors as reported by WMI
NumberOfProcessors int Number of processors as reported by WMI
ObjectStateID bigint Internal ID that references the ObjectState entity (Foreign Key)
OperatingSystem nvarchar Full name of the OS
OperatingSystemBits int 32 or 64 bit
OperatingSystemBuild nvarchar Build number of the OS
OperatingSystemCsdVersion nvarchar CSDVersion field for Windows systems. This file may be interpreted by partner systems such as Flexera One.
OperatingSystemDisplayVersion nvarchar DisplayVersion for operating systems that support this attribute. Newer Windows versions use this instead of ReleaseID.
OperatingSystemEdition nvarchar An OS specific edition marker
OperatingSystemExtraData nvarchar Extra data collected for operating system identification
OperatingSystemFamily nvarchar A short name to identify different operating system families
OperatingSystemInstallDate datetime2 Date/Time this OS instance was installed (as reported by WMI)
OperatingSystemLanguage nvarchar Language of the operating system as reported by WMI in cleartext
OperatingSystemLastBootUpTime datetime2 DateTime the operating system last booted
OperatingSystemMajor int Major version
OperatingSystemMinor int Minor version
OperatingSystemPrintableName nvarchar Consolidated operating system name for use in queries and reports
OperatingSystemProductInfo bigint For Windows, contains the result of the GetProductInfo() system call.
OperatingSystemProductName nvarchar For Windows, contains the ProductName value as scanned from the registry.
OperatingSystemPublisher nvarchar Publisher of the OS. 
OperatingSystemRelease nvarchar An OS specific release marker. For Windows 10 contains the 'Version'.
OperatingSystemServer bit True if this OS is a server version
OperatingSystemSoftwarePublisherID bigint Internal ID that references the SoftwarePublisher entity (Foreign Key)
OperatingSystemSuiteMask bigint For Windows, contains the SuiteMask.
OperatingSystemUniqueID nvarchar Unique operating system ID if supported by the operating system. May not change during the lifetime of the operating system instance. May change at re-install of the OS.
OperatingSystemUpdateBuildRevision bigint Windows UBR number
OperatingSystemVersion nvarchar Additional version information about the OS
OracleCoreFactor float Oracle Core Factor to use for Oracle pricing. Queries should alwas use this field.
OracleCoreFactorFromCatalog float Oracle Core Factor as determined by the OctoSAM catalog
OracleCoreFactorManual float Optional manually entered Oracle Core Factor
OracleCoreFactorOverride bit When True, the manual Oracle Core Factor overrides the factor from the catalog.
OrganizationID bigint Internal ID that references the Organization entity (Foreign Key)
OrganizationID bigint Internal ID that references the Organization entity (Foreign Key)
PCSystemType nvarchar PC system type as defined in WMI
PhysicalMemory bigint Amount of physical memory in the system as reported by WMI
PrintableName nvarchar Use this name in reports for consistency and to avoid having to build the printable name from its parts
Processor nvarchar Processor Name as reported by WMI
ProcessorFamily nvarchar Processor family as defined in WMI
ProcessorManufacturerID bigint Internal ID that references the Manufacturer entity (Foreign Key)
ProcessorSpeed bigint Max speed of the processor in MHz
RawManufacturer nvarchar Manufacturer of the machine as defined in WMI
Res1 nvarchar Reserved for future use
Res2 nvarchar Reserved for internal use by future versions
Res3 nvarchar Reserved for future use
Res4 nvarchar Reserved for future use
ServiceNowInstallStatus nvarchar install_status of the computer replicated from ServiceNow
ServiceNowLastExport datetime2 Date/Time of last export to ServiceNow
ServiceNowLastImport datetime2 Date/time of last import from ServiceNow
ServiceNowOperationalStatus nvarchar operation_status of the computer replicated from ServiceNow
ServiceNowSupportGroup nvarchar support_group of the computer object in ServiceNow
ServiceNowSysID uniqueidentifier ServiceNow: sys_id of the replicated object
ServiceNowTargetClass nvarchar ServiceNow: target class of the replicated object
SID nvarchar Computer SID
SoftwareDevelopment bit This flag can be set to mark machines used for software development. These machines usually have different licensing requirements.
SuggestSoftwareUninstall bit If true, suggest this machine in reports / queries for software uninstalls.
SynchLastSynch datetime2 Date/Time of last synchronization of this machine with the partner CMDB. Not used by OctoSAM Inventory
SynchTokenID nvarchar 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
TerminalServicesInstalled bit True, if Terminal Services are installed
VirtualizationHost bit True if this machine hosts virtual machines
VirtualizationManagementSystemID bigint Internal ID that references the VirtualizationManagementSystem entity (Foreign Key)
VirtualMachine bit True if this is a virtual machine
VirtualMachineGUID uniqueidentifier Optional. Used for mapping virtual machine information for MS Hyper-V and possibly other systems that use a GUID to identify a virtual machine.