| 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 |
string |
true |
Operating System installed on this machine as reported by OctoSAM scanners |
| 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 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. |