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