| 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 |
| Organization Description |
string |
false |
Description for the organization this entity is mapped to |
| Machine ID |
numeric |
false |
Internal ID that references the Machine 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) |
| Machine Description |
string |
true |
Description of this machine |
| Domain Name |
string |
false |
Windows NETBIOS Domain Name |
| Site |
string |
false |
Name of the Active Directory Site that this machine belogs to |
| Location |
string |
false |
Location attribute from Active Directory |
| Network Address |
string |
false |
Network address, usually the IP number |
| Network Mac Address |
string |
false |
MAC address of the main interface (corresponds to NetworkNetworkAddress |
| Network Subnet Mask |
string |
false |
Subnet mask if network address is an ip number |
| Virtual Machine |
bool |
false |
True if this is a virtual machine |
| Raw Manufacturer |
string |
false |
Manufacturer of the machine as defined in WMI |
| Manufacturer ID |
numeric |
false |
Internal ID that references the Manufacturer entity (Foreign Key) |
| Manufacturer |
string |
false |
Normalized manufacturer information. See field 'Raw Manufacturer' for scanned information |
| Model |
string |
false |
Model of the Machine as defined in WMI |
| Chassis Types |
string |
false |
ChassisTypes as reported in WMI in cleartext |
| Network Network Address |
string |
false |
Network address calculated from NetworkAddress and NetworkSubnetkMask fields |
| Operating System |
string |
false |
Full name of the OS |
| Operating System Server |
bool |
false |
True if this OS is a server version |
| Operating System Version |
string |
false |
Additional version information about the OS |
| Last Scan |
date |
false |
Date/Time of the last imported scan for this machine as reported by the machine (may be out of sync) |
| Software Signature ID |
numeric |
false |
Internal ID that references the SoftwareSignature entity (Foreign Key) |
| Software Signature |
string |
true |
Software signature as reported by the OctoSAM scanners |
| Raw Publisher |
string |
true |
Publisher string as scanned from the system. See field 'Publisher' for normalized publisher |
| Version |
string |
false |
Version Information from the MSI registry (if known) |
| Base Version |
string |
false |
Signature version determined by per-product logic within OctoSAM for signatures where uniform versioning has a special relevance such as Java |
| Software Package ID |
numeric |
false |
Internal ID that references the SoftwarePackage entity (Foreign Key) |
| Software Package |
string |
true |
Software package name from the OctoSAM software catalog |
| Metering Enabled |
bool |
false |
True, if the software package definition supports package metering |
| Software Category |
string |
true |
Software category name form the OctoSAM software catalog |
| Software Licensing Type ID |
numeric |
false |
Internal ID that references the SoftwareLicensingType entity (Foreign Key) |
| Licensing Type |
string |
true |
Licensing type for this package as defined in the OctoSAM Inventory software catalog |
| Licensing Relevant |
bool |
true |
True if the package or licensing type is considered relevant for licensing |
| Junk |
bool |
true |
This software category or signature is marked as 'Junk'. It should not have any influence on software licensing. |
| Install Date |
date |
false |
Date/Time of installation if available. Not all packages provide an install date. |
| First Scan |
date |
false |
Date/Time of first scan of this machine |
| Machine Signature Last Scan |
date |
false |
Date/Time of last scan that updated this software signature to machine relation |
| Last Found In Directory |
date |
false |
Time the object was last found in the directory service |
| Directory Path |
string |
false |
Path where the machine was found in the directory service. Usually an LDAP path. |
| Most Frequent User ID |
numeric |
false |
Internal ID that references the User entity (Foreign Key) |
| Most Frequent User |
string |
false |
User that is most frequently using this machine |
| Most Frequent User Login Name |
string |
false |
|
| Most Frequent User Domain Name |
string |
false |
|
| Most Frequent User Display Name |
string |
false |
|
| Most Frequent User Principal Name |
string |
false |
|
| Most Frequent User Mail |
string |
false |
|
| Most Frequent User Last Scan |
date |
false |
|
| Most Frequent User Local Administrator |
bool |
false |
|
| Most Freqeunt U Ser Last Login Was Remote |
bool |
true |
|
| Last User ID |
numeric |
false |
Internal ID that references the User entity (Foreign Key) |
| Last User |
string |
false |
User that last used this machine |
| Last User Display Name |
string |
true |
|
| Last User Login Name |
string |
false |
Login name of the last user that used this machine |
| Last User Domain Name |
string |
false |
Domainname of the last user that used this machine |
| Last User Principal Name |
string |
false |
|
| Last User Mail |
string |
false |
|
| Last User Last Scan |
date |
false |
|
| Last U Ser Local Administrator |
bool |
false |
|
| Last User Login Was Remote |
bool |
true |
|
| Custom Field1 |
string |
false |
Available for custom data for this machine, not used by OctoSAM Inventory |
| Custom Field2 |
string |
false |
Available for custom data for this machine, not used by OctoSAM Inventory |
| Custom Field3 |
string |
false |
Available for custom data for this Machine, not used by OctoSAM Inventory |
| Custom Field4 |
string |
false |
Available for custom data for this Machine, not used by OctoSAM Inventory |
| Current Date Time |
date |
false |
Date and time the query was run. For reference if you use and save query results. |