| Organization ID |
numeric |
false |
Internal ID that references the Organization entity (Foreign Key) |
| Organization |
string |
true |
Name of the organization this entity is mapped to |
| Machine ID |
numeric |
false |
Internal ID for the Machine entity (Primary Key) |
| Machine Guid |
guid |
false |
A unique ID that can be used to link to this machine object by external applications |
| Machine |
string |
true |
Distinct machine name. Use Column Chooser to show partial values such as Name or Domain of machines |
| Domain Name |
string |
false |
Windows NETBIOS Domain Name |
| Machine Name |
string |
false |
Machine name (computer name) |
| User Organization ID |
numeric |
false |
OctoSAM internal ID of this user's organization entity |
| User Organization |
string |
false |
Name of the organization this user is mapped to |
| User ID |
numeric |
false |
OctoSAM Inventory internal ID of the user entity |
| User Guid |
guid |
false |
OctoSAM Inventory internal Guid of the user entity |
| User |
string |
true |
Distinct user name. Use Column Chooser to show partial values such as Login Name, Domain or Display Name of users |
| Application |
string |
true |
|
| Add In |
string |
true |
|
| Bits |
numeric |
true |
|
| Friendly Name |
string |
true |
|
| Display Version |
string |
true |
|
| Product Version |
string |
true |
|
| In Proc Server |
string |
true |
|
| Company Name |
string |
true |
|
| 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 |
string |
true |
Operating System installed on this machine as reported by OctoSAM scanners |
| Manufacturer ID |
numeric |
false |
Internal ID that references the Manufacturer entity (Foreign Key) |
| Manufacturer |
string |
true |
Normalized manufacturer information. See field 'Raw Manufacturer' for scanned information |
| Raw Manufacturer |
string |
false |
Manufacturer of the machine as defined in WMI |
| Model |
string |
true |
Model of the Machine as defined in WMI |
| Most Frequent User ID |
numeric |
false |
Internal ID that references the User entity (Foreign Key) |
| Most Frequent User Guid |
guid |
false |
OctoSAM internal Guid of the user that is most frequently using this machine |
| Most Frequent User Organization ID |
numeric |
false |
|
| Most Frequent User |
string |
true |
User that is most frequently using this machine |
| Most Frequent User Display Name |
string |
false |
|
| Most Frequent User Login Name |
string |
true |
|
| Most Frequent User Domain Name |
string |
false |
|
| Most Frequent User Principal Name |
string |
false |
|
| Most Frequent User Mail |
string |
false |
|
| Last User ID |
numeric |
false |
Internal ID that references the User entity (Foreign Key) |
| Last User Guid |
guid |
false |
OctoSAM internal guid of the user that last used this machine |
| Last User Organization ID |
numeric |
false |
|
| Last User |
string |
true |
User that last used this machine |
| Last User Display Name |
string |
false |
|
| Last User Login Name |
string |
false |
Login name of the last user that used this machine |
| Last User Principal Name |
string |
false |
|
| Last User Mail |
string |
false |
|
| Current Date Time |
date |
false |
Date and time the query was run. For reference if you use and save query results. |