| 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. |
| Sid |
string |
false |
Computer SID |
| 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 |
| 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. |
| Manufacturer ID |
numeric |
false |
Internal ID that references the Manufacturer entity (Foreign Key) |
| Manufacturer |
string |
false |
Normalized hardware manufacturer name |
| 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, |
| 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) |
| Software Package ID |
numeric |
false |
Internal ID that references the SoftwarePackage entity (Foreign Key) |
| 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 Category ID |
numeric |
false |
Internal ID that references the SoftwareCategory entity (Foreign Key) |
| Software Category |
string |
true |
Name of the software category |
| Software Category Description |
string |
false |
Description |
| Junk |
bool |
false |
Flag to signal a category as junk. junk categories can be ignored on some reports and queries. |
| Software Package |
string |
true |
Name of the software package |
| Software Package Custom Field1 |
string |
false |
Custom data not used by OctoSAM |
| Software Package Custom Field2 |
string |
false |
Custom data not used by OctoSAM |
| Software Package Custom Field3 |
string |
false |
Custom Data - not used by OctoSAM Inventory |
| Software Package Custom Field4 |
string |
false |
Custom Data - not used by OctoSAM Inventory |
| Metering Enabled |
bool |
false |
True, if the software package definition supports package metering. |
| Predefined By Octopus |
bool |
false |
The package definition is maintained through OctoSAM master catalog updates |
| Predefined Site Specific |
bool |
false |
The package definition is maintained by Octosoft through OctoSAM site specific master catalog updates |
| Software Publisher ID |
numeric |
false |
Internal ID that references the SoftwarePublisher entity (Foreign Key) |
| Software Publisher |
string |
true |
Software publisher's name |
| Software Publisher Guid |
guid |
false |
Unique identifier for objects that are synchronized with the master catalog |
| Software Publisher Url |
string |
false |
Link to the Website |
| Software Licensing Type |
string |
true |
Name |
| Licensing Relevant |
bool |
true |
True for commercial licensing types |
| Usage Days |
numeric |
true |
Number of Usage Days for the package on this machine |
| Current Date Time |
date |
false |
Date and time the query was run. For reference if you use and save query results. |