Software Publisher ID |
numeric |
false |
OctoSAM internal ID of this software publisher entity |
Software Publisher Guid |
guid |
false |
OctoSAM internal Guid of this software publisher entity |
Software Publisher |
string |
true |
Normalized software publisher from the OctoSAM catalog |
Software Package ID |
numeric |
false |
OctoSAM internal ID of this software package entity |
Software Package Guid |
guid |
false |
OctoSAM internal Guid of this sofware package entity |
Software Package |
string |
true |
Software package name from the OctoSAM software catalog |
Lifecycle Start Date |
date |
true |
|
Lifecycle Long Term Support |
bool |
true |
|
Lifecycle Mainstream End Date |
date |
true |
|
Install Date |
date |
true |
Date this software package got installed. Depending on the installer used this date may not be available. |
Mainstream Expired |
bool |
true |
|
Lifecycle Extended End Date |
date |
true |
|
Extended Expired |
bool |
true |
|
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) |
Indicator Signature |
string |
true |
|
Current Date Time |
date |
false |
Date and time the query was run. For reference if you use and save query results. |