| 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 |
false |
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 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 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, |
| 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) |
| 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) |
| Installation Custom Field1 |
string |
false |
|
| Installation Custom Field2 |
string |
false |
|
| Installation Custom Field3 |
string |
false |
|
| Installation Custom Field4 |
string |
false |
|
| Softwarepackage ID |
numeric |
false |
|
| Software Package Guid |
guid |
false |
GUID used for catalog updates. Stays the same for all OctoSAM defined software packages through the lifecycle of the package definition. Allows rename and delete of packages during catalog update.. Do not set if definig your own custom packages directly in the database. |
| Software Package |
string |
true |
Software package name from the OctoSAM software catalog |
| Software Item Guid |
guid |
false |
OctoSAM internal Guid of this SoftwareItem entity |
| Software Item |
string |
true |
Name of the software item |
| Base Version |
string |
true |
|
| Install Date |
date |
false |
Date this software package got installed. Depending on the installer used this date may not be available. |
| Package Installation Approved |
bool |
false |
|
| Package Installation Approved Changed |
date |
true |
|
| Package Installation Approved Changed By |
string |
true |
|
| Current Date Time |
date |
false |
Date and time the query was run. For reference if you use and save query results. |