| Software Package ID |
string |
false |
OctoSAM internal ID of this software package entity |
| 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 |
| 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 Edition |
string |
false |
An OS specific edition marker |
| Operating System Bits |
numeric |
false |
32 or 64 bit |
| 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 |
| 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 |
| Processor |
string |
false |
Processor Name as reported by WMI |
| Processor Speed |
numeric |
false |
Max speed of the processor in MHz |
| 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 always 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 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 consistent 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 |
Access |
| Last User ID |
numeric |
false |
Internal ID that references the User entity (Foreign Key) |
| Last User |
string |
false |
Combination of attributes for consistent 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) |
| 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 |
| Virtual Machine |
bool |
true |
True if this is a virtual machine |
| Virtualization Host |
bool |
false |
True if this machine hosts virtual machines |
| Last Scan |
date |
true |
Date/Time of the last imported scan for this machine as reported by the machine (may be out of sync) |
| Current Date Time |
date |
false |
Date and time the query was run. For reference if you use and save query results. |