Machine (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 rows and columns from the Machine table.
Fields¶
| Name | Type | Visible | Description |
|---|---|---|---|
| ID | numeric | true | OctoSAM internal ID of this entity |
| Organization ID | numeric | true | OctoSAM internal ID of this Organization entity |
| Last Scan | date | true | Date/Time this entity got scanned last |
| Name | string | true | Machine name (computer name) |
| Alternate Name | string | true | Contains the computer name for systems that may have different host and computer names, such as macOS. |
| 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 | true | Version of the Operating System installed on this machine as reported by OctoSAM scanners |
| Operating System Build | string | true | Build number of the OS |
| Operating System Major | numeric | true | Major version |
| Operating System Minor | numeric | true | Minor version |
| Operating System Server | bool | true | True if this OS is a server version |
| Fully Qualified Domain Name | string | true | Fully qualified domain name as seen by the scanner through reverse lookup of the network address |
| Network Address | string | true | Network address, usually the IP number. |
| Last Modification | date | true | Date/Time this entity was last updated. In most cases, this is the time of the last import. In case of re-import of older scan files, LastModification can differ significantly from LastScan. |
| Import Source ID | numeric | true | ID of the import module that created the entity. 1=OctoscanImportService. |
| Custom Field1 | string | true | Available for custom data for this machine, not used by OctoSAM Inventory. |
| Custom Field2 | string | true | Available for custom data for this machine, not used by OctoSAM Inventory. |
| Notes | string | true | Available for custom notes about this entity |
| Directory Path | string | true | Path to this user or machine object in Active Directoy |
| Directory Container Path | string | true | Path to the container of this user or machine object in Active Directory |
| Description | string | true | Description attribute of the directory service or manually entered during offline scan |
| Alternate Description | string | true | Alternate description field specific to the scanned machine type. For example locally entered description in macOS. |
| Importer Instance | string | true | Name of the ImporterInstance. Used if you have multiple import module instances writing into the same database. |
| Last Scan GUID | guid | true | Global Unique IDentifier of the last scan |
| Last Hardware Scan | date | true | Time of the last imported WMI scan |
| Last Hardware Scan GUID | guid | true | GUID of the last imported WMI scan |
| Last Signature Scan | date | true | Time of the last imported software signature scan for this machine |
| Last Signature Scan GUID | guid | true | GUID of the last imported software signature scan for this machine |
| Last Ual Scan | date | true | Time of the last imported User Access Logging scan on this machine. Null for machines that don't support UAL. |
| Last Ual Scan GUID | guid | true | GUID of the last imported User Access Logging scan on this machine. Null for machines that don't support UAL. |
| Exclude From Software Inventory | bool | true | 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. |
| Ignore New Signatures | bool | true | 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. |
| Found In Directory | bool | true | True if the object could be found in Active Directory at last check |
| Last Found In Directory | date | true | Time the object was last found in the directory service |
| Terminal Services Installed | bool | true | True, if Terminal Services are installed |
| Created | date | true | Date/Time this entity was created |
| Created GUID | guid | true | Unique id of the .scan file that created this object |
| Last User ID | numeric | true | OctoSAM internal ID of the user that last used this machine |
| Most Frequent User ID | numeric | true | OctoSAM internal ID of the user that is most frequently using this machine |
| Custom Field3 | string | true | Available for custom data for this Machine, not used by OctoSAM Inventory |
| Custom Field4 | string | true | Available for custom data for this Machine, not used by OctoSAM Inventory |
| Synch Token ID | string | true | 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 |
| Synch Last Synch | date | true | Date/Time of last synchronization of this machine with the partner CMDB. Not used by OctoSAM Inventory |
| Last Modified By | string | true | Windows User ID that last updated this Machine record through the UI |
| Ignore For Rollout | bool | true | Reserved for future use |
| Network Subnet Mask | string | true | Subnet mask if network address is an ip number |
| Directory Site Name | string | true | Active Directory Site that the machine belongs to |
| Network Network Address | string | true | Network address calculated from NetworkAddress and NetworkSubnetkMask fields |
| Network Network Name | string | true | Network name can be set from an external source. Not used by OctoSAM. |
| Network Network CIDR | string | true | Network in CIDR notation |
| Res2 | string | true | Reserved for internal use by future versions |
| Directory Location | string | true | Active Directory location attribute |
| Directory Ext1 | string | true | Site specific data, can optionally be used to load site-specific extended schema properties. |
| Directory Ext2 | string | true | Site specific data, can optionally be used to load site-specific extended schema properties. |
| Directory Ext3 | string | true | Site specific data, can optionally be used to load site-specific extended schema properties. |
| Directory Ext4 | string | true | Site specific data, can optionally be used to load site-specific extended schema properties. |
| Res3 | string | true | Reserved for future use |
| Res4 | string | true | Reserved for future use |
| Domain Name | string | true | NETBIOS Domain name |
| Printable Name | string | true | Use this name in reports for consistency and to avoid having to build the printable name from its parts |
| Raw Manufacturer | string | true | Manufacturer string as scanned from the system. See field 'Manufacturer' for normalized manufacturer |
| Model | string | true | Model of the Machine as defined in WMI |
| Bios Serial Number | string | true | BIOS Serial Number as reported by WMI |
| Bios Name | string | true | BIOS Name as reported by WMI |
| Bios Version | string | true | BIOS Version as reported by WMI |
| Bios Sm Bios Version | string | true | SMBIOS Version as reported by WMI |
| Processor | string | true | Processor Name as reported by WMI |
| Physical Memory | numeric | true | Amount of physical memory in the system as reported by WMI |
| Chassis Types | string | true | ChassisTypes as reported in WMI in cleartext |
| Operating System Install Date | date | true | Date/Time this OS instance was installed (as reported by WMI) |
| Operating System Language | string | true | Language of the operating system as reported by WMI in cleartext |
| Directory Last Logon Timestamp | date | true | LastLogonTimestamp attribute from Active Directory (updated on import and on housekeeping). Resolution: 14days. |
| Directory User Account Control | numeric | true | UserAccountControl attribute from Active Directory (updated on import and on housekeeping) |
| Directory Disabled | bool | true | True if the UserAccountControl attribute has the disable bit set |
| Directory GUID | guid | true | GUID of a machine if joined to active directory and supported by the operating system and scanner |
| Number Of Processors | numeric | true | Number of processors as reported by WMI |
| Number Of Logical Processors | numeric | true | Number of logical processors as reported by WMI |
| Number Of Cores | numeric | true | Number of cores as reported by WMI |
| Virtual Machine | bool | true | True if this is a virtual machine |
| Virtualization Host | bool | true | True if this machine hosts virtual machines |
| First Scan | date | true | Date/Time this entity got scanned first |
| SID | string | true | Computer SID |
| Msft Direct Access Configured | bool | true | True if Microsoft Direct Access configuration was found at last scan |
| Virtual Machine GUID | guid | true | Optional. Used for mapping virtual machine information for MS Hyper-V and possibly other systems that use a GUID to identify a virtual machine. |
| PC System Type | string | true | PC system type as defined in WMI |
| Processor Family | string | true | Processor family as defined in WMI |
| Active | bool | true | If true, do not count this machine for installations |
| Network Mac Address | string | true | MAC address of the main interface (corresponds to NetworkNetworkAddress |
| Res1 | string | true | Reserved for future use |
| Hardware Unique ID | string | true | Unique hardware ID if supported by the hardware. May not change with operating system re-install for physical systems. |
| Operating System Unique ID | string | true | 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. |
| Directory Extension Attribute1 | string | true | ExtensionAttribute from Active Directory |
| Directory Extension Attribute2 | string | true | ExtensionAttribute from Active Directory |
| Directory Extension Attribute3 | string | true | ExtensionAttribute from Active Directory |
| Directory Extension Attribute4 | string | true | ExtensionAttribute from Active Directory |
| Directory Extension Attribute5 | string | true | ExtensionAttribute from Active Directory |
| Directory Extension Attribute6 | string | true | ExtensionAttribute from Active Directory |
| Directory Extension Attribute7 | string | true | ExtensionAttribute from Active Directory |
| Directory Extension Attribute8 | string | true | ExtensionAttribute from Active Directory |
| Directory Extension Attribute9 | string | true | ExtensionAttribute from Active Directory |
| Directory Extension Attribute10 | string | true | ExtensionAttribute from Active Directory |
| Directory Extension Attribute11 | string | true | ExtensionAttribute from Active Directory |
| Directory Extension Attribute12 | string | true | ExtensionAttribute from Active Directory |
| Directory Extension Attribute13 | string | true | ExtensionAttribute from Active Directory |
| Directory Extension Attribute14 | string | true | ExtensionAttribute from Active Directory |
| Directory Extension Attribute15 | string | true | ExtensionAttribute from Active Directory |
| Directory When Changed | date | true | WhenChanged attribute from Active Directory (updated on import and on housekeeping) |
| Directory When Created | date | true | WhenCreated attribute from Active Directory |
| Suggest Software Uninstall | bool | true | If true, suggest this machine in reports / queries for software uninstalls. |
| Hint Software Package Usage Start Date | date | true | Min consolidated usage date for this Machine |
| Hint Software Package Usage End Date | date | true | Max consolidated usage date for this Machine |
| Hint In Groups | bool | true | True if the Machine is member in any group |
| Hint Has Wmi | bool | true | True if there is hardware and configuration data (WMI) available for the machine |
| Hint Has Software Items | bool | true | True if software items are linked to this machine |
| Hint Is Cluster Member | bool | true | True if the machine is member of a custer |
| Operating System Release | string | true | An OS specific release marker. For Windows 10 contains the 'Version'. |
| Operating System Edition | string | true | An OS specific edition marker |
| Operating System Product Name | string | true | For Windows, contains the ProductName value as scanned from the registry. |
| Operating System Suite Mask | numeric | true | For Windows, contains the SuiteMask. |
| Operating System Product Info | numeric | true | For Windows, contains the result of the GetProductInfo() system call. |
| Operating System Bits | numeric | true | 32 or 64 bit |
| Operating System Publisher | string | true | Publisher of the operating system |
| Guid | guid | true | A unique ID that can be used to link to this machine object by external applications |
| Bios Asset Tag | string | true | A site specific tag that can be stored in the BIOS of the machine |
| Deleted In Directory | bool | true | True, if directory check detects that the machine is no longer found in directory. |
| Deleted In Directory First Detected | date | true | Date/Time the delete flag was set |
| Directory Account Expires | date | true | AccountExpires attribute from ActiveDirectory |
| Operating System Printable Name | string | true | Consolidated operating system name for use in queries and reports |
| Hint Has Access Log | bool | true | True if machine has UAL data available |
| Hint Has Swid Documents | bool | true | True if machine has scanned SWID documents |
| Analysis Extras | string | true | Holds additional analysis data |
| Virtualization Management System ID | numeric | true | OctoSAM internal ID of the virtualization management system |
| Oracle Core Factor | object | true | Oracle Core Factor to use for Oracle pricing. Queries should alwas use this field. |
| Oracle Core Factor From Catalog | object | true | Oracle Core Factor as determined by the OctoSAM catalog |
| Oracle Core Factor Manual | object | true | Optional manually entered Oracle Core Factor |
| Oracle Core Factor Override | bool | true | When True, the manual Oracle Core Factor overrides the factor from the catalog. |
| Software Development | bool | true | This flag can be set to mark machines used for software development. These machines usually have different licensing requirements. |
| Processor Speed | numeric | true | Max speed of the processor in MHz |
| Network Default Gateway | string | true | Network default gateway |
| Network DHCP | bool | true | True if DHCP is enabled on the main interface of the machine |
| Network DNS | string | true | Addresses of configured DNS servers |
| Operating System Last Boot Up Time | date | true | DateTime the operating system last booted |
| Service Now Sys ID | guid | true | ServiceNow: sys_id of the replicated object |
| Service Now Target Class | string | true | ServiceNow: target class of the replicated object |
| Service Now Last Export | date | true | Date/Time of last export to ServiceNow |
| Service Now Last Import | date | true | Date/time of last import from ServiceNow |
| Manufacturer ID | numeric | true | OctoSAM internal ID of the machine manufacturer |
| Processor Manufacturer ID | numeric | true | OctoSAM internal ID of the machine processor manufacturer |
| Bios Sm Bios Uuid | guid | true | SMBIOS UUID of the machine |
| Operating System Display Version | string | true | DisplayVersion for operating systems that support this attribute. Newer Windows versions use this instead of ReleaseID. |
| Operating System Csd Version | string | true | CSDVersion field for Windows systems. This file may be interpreted by partner systems such as Flexera One. |
| Operating System Software Publisher ID | numeric | true | OctoSAM internal ID of this software publisher |
| Extra Data | string | true | Extra data for this object (JSON) |
| Cost Center | string | true | Cost center - typically replicated from another system |
| Operating System Update Build Revision | numeric | true | Windows UBR number |
| Operating System Extra Data | string | true | Extra data collected for operating system identification |
| Entra Id Tenant Id | guid | true | Entra ID tenant id for machines that are Entra ID joined |
| Object State ID | numeric | true | Internal ID that references the ObjectState entity (Foreign Key) |
| Hint Has Auto Start | bool | true | True if machine has scanned Windows AutosStart information |
| Mapping Tag | string | true | This field can be used for custom mapping logic |
| Hint Has Mui Cache | bool | true | True if this machine has scanned Windows MUI information |
| Entra Id Device Id | string | true | Device ID from Entra ID |
| Entra Id Id | string | true | ID from Entra ID |
| Cloud Provider Account ID | numeric | true | Internal ID that references the CloudProviderAccount entity (Foreign Key) |
| Entra Id Device Ownership | string | true | DeviceOwnership field from Entra ID |
| Entra Id Enrollment Profile Name | string | true | EnrollmentProfileName field from Entra ID |
| Entra Id On Premises Last Sync Date Time | date | true | OnPremisesLastSyncDateTime field from Entra ID |
| Entra Id Trust Type | string | true | TrustType field from Entra ID |
| Entra Id Profile Type | string | true | ProfileType field from Entra ID |
| Entra Id Registration Date Time | date | true | RegistrationDateTime field from Entra ID |
| Last Found In Entra Id | date | true | Date/Time this device was last found in Entra ID |
| Entra Id Approximate Last Sign In Date Time | date | true | ApproximateLastSignInDateTime field Entra ID |
| Entra Id Is Managed | bool | true | True if this machine is managed by Entra ID MDM policies |
| Entra Id Is Compliant | bool | true | True if this machine is deemed compliant to Entra ID MDM policies |
| Last Scanner Tag | string | true | Command-line tag that was specified on the last scan of this machine |
| Entra Id On Premises Sync Enabled | bool | true | True if on premises sync is enabled for this machine in Entra ID |
| Entra Id Extension Attribute1 | string | true | Extension attribute 1 from Entra ID |
| Entra Id Extension Attribute2 | string | true | Extension attribute 2 from Entra ID |
| Entra Id Extension Attribute3 | string | true | Extension attribute 3 from Entra ID |
| Entra Id Extension Attribute4 | string | true | Extension attribute 4 from Entra ID |
| Entra Id Extension Attribute5 | string | true | Extension attribute 5 from Entra ID |
| Entra Id Extension Attribute6 | string | true | Extension attribute 6 from Entra ID |
| Entra Id Extension Attribute7 | string | true | Extension attribute 7 from Entra ID |
| Entra Id Extension Attribute8 | string | true | Extension attribute 8 from Entra ID |
| Entra Id Extension Attribute9 | string | true | Extension attribute 9 from Entra ID |
| Entra Id Extension Attribute10 | string | true | Extension attribute 10 from Entra ID |
| Entra Id Extension Attribute11 | string | true | Extension attribute 11 from Entra ID |
| Entra Id Extension Attribute12 | string | true | Extension attribute 12 from Entra ID |
| Entra Id Extension Attribute13 | string | true | Extension attribute 13 from Entra ID |
| Entra Id Extension Attribute14 | string | true | Extension attribute 14 from Entra ID |
| Entra Id Extension Attribute15 | string | true | Extension attribute 15 from Entra ID |
| Last Basic Hardware From Wmi | date | true | Date/Time basic hardware info was last calculated from WMI for this machine |
| Hint Has Office Add Ins | bool | true | True if this machine has registered Microsoft Office add-ins |
| Cost Center ID | numeric | true | Internal ID that references the CostCenter entity (Foreign Key) |
| Service Now Install Status | string | true | Install_status of the computer replicated from ServiceNow |
| Service Now Operational Status | string | true | Operation_status of the computer replicated from ServiceNow |
| Service Now Support Group | string | true | Support_group of the computer object in ServiceNow |
| Environment ID | numeric | true | Internal ID that references the Environment entity (Foreign Key) |
| Hint Has Browser Extensions | bool | true | |
| 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¶
Query information¶
| Property | Value | Description |
|---|---|---|
| Query Guid | 255dbd0e-481d-4c60-8fcb-e2f62a802b28 | The internal id of the query. Must be unique |
| SupportsDesktop | true | If true, the query can be started from the OctoSAM Windows GUI |
| SupportsWeb | false | If true, the query can be started from the OctoSAM Web UI |