| 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 |
| Network Address |
string |
false |
Network address, usually the IP number. |
| Network Mac Address |
string |
false |
MAC address of the main interface (corresponds to NetworkNetworkAddress |
| 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 |
| 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 |
| 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 |
| 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, |
| 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 |
| 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 Package |
string |
true |
Software package name from the OctoSAM software catalog |
| Software Category |
string |
true |
Software category name form the OctoSAM software catalog |
| Software Publisher |
string |
true |
Normalized software publisher from the OctoSAM catalog |
| Metering Enabled |
bool |
true |
True, if the software package definition supports package metering. |
| Auto Assign Enabled |
bool |
true |
Auto assign rules for new signatures enabled |
| Software Package Usage Days |
numeric |
true |
Usage days within the selected timespan |
| Metered Since |
date |
true |
|
| First Usage |
date |
true |
|
| Last Usage |
date |
true |
Date/Time the software package was last used on the machine. Redundant information to SoftwarePackageUsageDetail provided for easier querying and performance. |
| Licensing Type ID |
numeric |
true |
OctoSAM internal ID for licensing type |
| Licensing Type |
string |
true |
Licensing type for this package as defined in the OctoSAM Inventory software catalog |
| Licensing Relevant |
bool |
true |
True if the package or licensing type is considered relevant for licensing |
| Junk |
bool |
true |
This software category or signature is marked as 'Junk'. It should not have any influence on software licensing. |
| Install Date |
date |
true |
Date this software package got installed. Depending on the installer used this date may not be available. |
| Current Date Time |
date |
false |
Date and time the query was run. For reference if you use and save query results. |