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 |
Browser |
string |
true |
|
Extension Code |
string |
false |
|
Display Name |
string |
true |
|
Version |
string |
true |
|
Store Url |
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 |
false |
|
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. |