| 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 |
Internal ID that references the Organization entity (Foreign Key) |
| User Organization |
string |
false |
Name of the organization this user is mapped to |
| User ID |
numeric |
false |
Internal ID for the User entity (Primary Key) |
| User Guid |
guid |
false |
A unique ID that can be used to link to this user object by external applications |
| 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 |
Name of the browser |
| Extension Code |
string |
false |
Publisher specific code of the extension |
| Display Name |
string |
true |
DisplayName attribute from the directory service |
| Version |
string |
true |
Version of the extension |
| Store Url |
string |
true |
Hyperlink to the extension in the store |
| Res1 |
string |
false |
Reserved for future use |
| Store |
string |
true |
|
| Last Found In Store |
date |
true |
Date/Time the extension was last found in the store |
| Stars |
object |
true |
Number of stars the extension has in the store. A floating point number is used since some stores (e.g. Chrome Web Store) use floating point numbers for ratings (e.g. 4.5 stars) |
| Ratings |
numeric |
true |
Number of ratings the extension has in the store |
| Sentry Block |
bool |
true |
Indicates if the extension is blocked by Sentry |
| Sentry Reason |
string |
true |
Reason for the Sentry block |
| Sentry Insert Date |
date |
true |
Date/Time the Sentry block was inserted |
| Sentry Source |
string |
true |
Source of the Sentry block |
| Store Alert |
string |
true |
Alert message from the extension store about this extension |
| Store Warning |
string |
true |
Warning message from the extension store about this extension |
| 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 |
| Last Scan |
date |
true |
Date/Time of the last imported scan for this machine as reported by the machine (may be out of sync) |
| Last Scan Guid |
guid |
false |
GUID of the last imported .scan file for this entity. |
| 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. |