| 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 |
false |
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 alwas 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 consisten 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 |
SAMAccount name, |
| 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 consisten 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 |
| Last Scan |
date |
true |
Date/Time of the last imported scan for this machine as reported by the machine (may be out of sync) |
| 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 |
| Cluster ID |
numeric |
false |
OctoSAM internal ID of the cluster |
| Cluster Name |
string |
true |
|
| Host Host Organization ID |
numeric |
false |
Internal ID that references the Organization entity (Foreign Key) |
| Host Host Organization Guid |
guid |
false |
|
| Host Host Organization |
string |
true |
Name of the organization |
| Host Host Organization Description |
string |
false |
Description |
| Host Host Environment ID |
numeric |
false |
Internal ID that references the Environment entity (Foreign Key) |
| Host Host Environment |
string |
false |
Name of the Environment |
| Host Host Organization Custom Field1 |
string |
false |
Available for custom data, not used by OctoSAM Inventory, |
| Host Host Organization Custom Field2 |
string |
false |
Available for custom data, not used by OctoSAM Inventory, |
| Host Host Organization Custom Field3 |
string |
false |
Available for custom data, not used by OctoSAM Inventory, |
| Host Host Organization Custom Field4 |
string |
false |
Available for custom data, not used by OctoSAM Inventory, |
| Host Host Object State ID |
numeric |
false |
Internal ID that references the ObjectState entity (Foreign Key) |
| Host Host Object State |
string |
false |
Object state name |
| Host Host Object State Octopus Id |
string |
false |
Octopus technical name of this state |
| Host Machine Guid |
guid |
false |
A unique ID that can be used to link to this machine object by external applications |
| Host Machine ID |
numeric |
false |
Internal ID for the Machine entity (Primary Key) |
| Host Machine Name |
string |
false |
Machine name (computer name) |
| Host Machine |
string |
true |
Use this name in reports for consistency and to avoid having to build the printable name from its parts |
| Host Alternate Name |
string |
false |
Contains the computer name for systems that may have different host and computer names, such as macOS. |
| Host Fully Qualified Domain Name |
string |
false |
Fully qualified domain name as seen by the scanner through reverse lookup of the network address |
| Host Machine Description |
string |
false |
Description attribute of the directory service or manually entered during offline scan |
| Host Alternate Description |
string |
false |
Alternate description field specific to the scanned machine type. For example locally entered description in macOS. |
| Host Domain Name |
string |
false |
Windows NETBIOS Domain Name |
| Host Sid |
string |
false |
Computer SID |
| Host Last Scan Guid |
guid |
false |
GUID of the last imported .scan file for this entity. |
| Host First Scan |
date |
false |
Date/Time of first scan of this machine |
| Host Manufacturer ID |
numeric |
false |
Internal ID that references the Manufacturer entity (Foreign Key) |
| Host Host Manufacturer |
string |
false |
Normalized hardware manufacturer name |
| Host Directory Last Logon Last Scan Diff |
numeric |
false |
|
| Host Custom Field1 |
string |
false |
Available for custom data for this machine, not used by OctoSAM Inventory. |
| Host Custom Field2 |
string |
false |
Available for custom data for this machine, not used by OctoSAM Inventory. |
| Host Custom Field3 |
string |
false |
Available for custom data for this Machine, not used by OctoSAM Inventory |
| Host Custom Field4 |
string |
false |
Available for custom data for this Machine, not used by OctoSAM Inventory |
| Host Notes |
string |
false |
Available for custom notes about this entity |
| Host Virtual Machine |
bool |
true |
True if this is a virtual machine |
| Host Virtualization Host |
bool |
false |
True if this machine hosts virtual machines |
| Host Mapping Tag |
string |
false |
This field can be used for custom mapping logic |
| Host Last Scanner Tag |
string |
false |
Command-line tag that was specified on the last scan of this machine |
| Host Last Scan |
date |
true |
Date/Time of the last imported scan for this machine as reported by the machine (may be out of sync) |
| Host Cluster ID |
numeric |
false |
OctoSAM internal ID of the cluster that this host is member of |
| Host Cluster Name |
string |
true |
Name of the cluster that this host is member of |
| Current Date Time |
date |
false |
Date and time the query was run. For reference if you use and save query results. |