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.