| Organization |
string |
true |
Name of the organization this entity is mapped to |
| 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 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 |
| Domain Name |
string |
false |
Windows NETBIOS Domain Name |
| Machine Name |
string |
false |
Machine name (computer name) |
| Virtual Machine |
bool |
false |
True if this is a virtual machine |
| Operating System |
string |
false |
Full name of the OS |
| Operating System Version |
string |
false |
Additional version information about the OS |
| Operating System Build |
string |
false |
Build number of the OS |
| Operating System Server |
bool |
false |
True if this OS is a server version |
| Raw Manufacturer |
string |
false |
Manufacturer of the machine as defined in WMI |
| Manufacturer |
string |
false |
Normalized manufacturer information. See field 'Raw Manufacturer' for scanned information |
| Model |
string |
false |
Model of the Machine as defined in WMI |
| Last Ual Scan |
date |
false |
Time of the last imported User Access Logging scan on this machine. Null for machines that don't support UAL. |
| Last Ual Scan GUID |
guid |
false |
GUID of the last imported User Access Logging scan on this machine. Null for machines that don't support UAL. |
| IP Address |
string |
true |
Microsoft UAL Device Access IP address |
| Client Machine ID |
numeric |
false |
OctoSAM Inventory internal ID of the client machine |
| Product Name |
string |
true |
Microsoft User Access Logging product name |
| Role Name |
string |
true |
Microsoft User Access Logging role name |
| Role G Uid |
guid |
false |
Microsoft User Access Logging role GUID |
| First Seen |
date |
true |
The date and time when an IP address was first used to access a role or service |
| Last Seen |
date |
true |
The date and time when an IP address was last used to access a role or service |
| Activity Count |
numeric |
true |
The number of times a particular device accessed the role or service |
| Client Organization |
string |
true |
Client's organization if the client is knwon to OctoSAM Inventory |
| Client Organization ID |
numeric |
false |
Client's organization OctoSAM internal ID |
| Client Machine Guid |
guid |
false |
Client machine object Guid if knwon to OctoSAM Inventory |
| Client Machine |
string |
true |
Client machine object if known to OctoSAM Inventory |
| Client Domain Name |
string |
false |
Client's domain name |
| Client Machine Name |
string |
false |
Client machine name if known to OctoSAM Inventory |
| Client Virtual Machine |
bool |
false |
True if client is a virtual machine |
| Client Operating System |
string |
false |
Client's operating system |
| Client Operating System Version |
string |
false |
Client's operating system version |
| Client Operating System Build |
string |
false |
Client's operating system build |
| Client Operating System Server |
bool |
false |
True if client's operating system is a server variant |
| Client Raw Manufacturer |
string |
false |
Manufacturer of the client machine as reported by UAL |
| Client Manufacturer |
string |
false |
Normalized manufacturer of the client machine |
| Client Model |
string |
false |
Client machine model |
| Current Date Time |
date |
false |
Date and time the query was run. For reference if you use and save query results. |