| Machine ID |
numeric |
false |
Internal ID that references the Machine entity (Foreign Key) |
| Machine Guid |
guid |
false |
A unique ID that can be used to link to this machine object by external applications |
| Organization ID |
numeric |
false |
Internal ID that references the Organization entity (Foreign Key) |
| Machine |
string |
true |
Distinct machine name. Use Column Chooser to show partial values such as Name or Domain of machines |
| Machine Name |
string |
false |
Machine name (computer name) |
| Domain Name |
string |
false |
Windows NETBIOS Domain Name |
| Software Package Id |
numeric |
false |
OctoSAM internal ID of this software package entity |
| 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 |
| Expired |
bool |
true |
True if support has expired for this installation |
| Operating System Product Name |
string |
true |
For Windows, contains the ProductName value as scanned from the registry. |
| Operating System Release |
string |
true |
An OS specific release marker. For Windows 10 contains the 'Version'. |
| Operating System Version |
string |
true |
Version of the Operating System installed on this machine as reported by OctoSAM scanners |
| Operating System Display Version |
string |
true |
DisplayVersion for operating systems that support this attribute. Newer Windows versions use this instead of ReleaseID. |
| Operating System Server |
bool |
false |
True if this OS is a server version |
| Last Scan |
date |
true |
Date/Time this entity got scanned last |
| Directory Last Logon Timestamp |
date |
false |
LastLogonTimestamp attribute from Active Directory (updated on import and on housekeeping). Resolution: 14days. |
| 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 |
| Lifecycle Definition Type |
string |
true |
Source of lifecycle definition. OctoSAM uses software lifecycle definition data from several sources |
| Lifecycle Support Policy |
string |
true |
Software Publisher specific lifecycle policy name |
| Lifecycle Start Date |
date |
true |
Start of software lifecycle |
| Lifecycle Mainstream End Date |
date |
true |
End of mainstream support date |
| Lifecycle Extended End Date |
date |
true |
End of extended support date |
| Lifecycle Retirement Date |
date |
true |
Product retirement date |
| Lifecycle Release Start Date |
date |
true |
Release start date |
| Lifecycle Release End Date |
date |
true |
Release end date |
| Current Date Time |
date |
false |
Date and time the query was run. For reference if you use and save query results. |