| Software Category ID |
numeric |
false |
Internal ID that references the SoftwareCategory entity (Foreign Key) |
| Software Category Sort Order |
numeric |
false |
OctoSAM internal code to support software category sorting regardless of name |
| Software Category |
string |
true |
Software category name form the OctoSAM software catalog |
| Software Package ID |
numeric |
false |
Internal ID that references the SoftwarePackage entity (Foreign Key) |
| Software Package Guid |
guid |
false |
GUID used for catalog updates. Stays the same for all OctoSAM defined software packages through the lifecycle of the package definition. Allows rename and delete of packages during catalog update.. Do not set if definig your own custom packages directly in the database. |
| 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 Publisher |
string |
true |
Normalized software publisher from the OctoSAM catalog |
| Software Package Publisher ID |
numeric |
false |
OcotoSAM internal ID of the package's software publisher |
| Software Package Publisher Guid |
guid |
false |
OcotoSAM internal Guid of the package's software publisher |
| Licensing Type ID |
numeric |
false |
OctoSAM internal ID for licensing type |
| Package Custom Field1 |
string |
false |
Custom data not used by OctoSAM |
| Package Custom Field2 |
string |
false |
Custom data not used by OctoSAM |
| Package Custom Field3 |
string |
false |
Custom Data - not used by OctoSAM Inventory |
| Package Custom Field4 |
string |
false |
Custom Data - not used by OctoSAM Inventory |
| Predefined By Octopus |
bool |
false |
The package definition is maintained through OctoSAM master catalog updates |
| Package Last Usage |
date |
false |
Date this software package was last used |
| Install Date |
date |
true |
Date/Time of installation if available. Not all packages provide an install date. |
| Installation Custom Field1 |
string |
false |
Custom field available for site-specific per installation data, Not used by OctoSAM logic. |
| Installation Custom Field2 |
string |
false |
Custom field available for site-specific per installation data, Not used by OctoSAM logic. |
| Installation Custom Field3 |
string |
false |
Custom field available for site-specific per installation data, Not used by OctoSAM logic. |
| Installation Custom Field4 |
string |
false |
Custom field available for site-specific per installation data, Not used by OctoSAM logic. |
| 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 |
| Software Signature ID |
numeric |
false |
Internal ID that references the SoftwareSignature entity (Foreign Key) |
| Software Signature Guid |
guid |
false |
A unique ID that can be used to link to this object by external applications |
| Signature |
string |
true |
Signature after signature rewriting process. Used to uniquely identify a software signature object. |
| Dynamic |
bool |
true |
Dynamic signatures do not appear on every scan. The absencence of this signature does not signify a software uninstall. |
| Comments |
string |
false |
Comment field from the Windows installer registry, |
| Contact |
string |
false |
Contact field from the Windows Installer Registry |
| Raw Publisher |
string |
true |
Publisher string as scanned from the system. See field 'Publisher' for normalized publisher |
| Signature Software Publisher |
string |
false |
Normalized software publisher of this signature from the OctoSAM catalog |
| Software Signature Publisher ID |
numeric |
false |
OctoSAM internal ID of this software publisher entity |
| Software Signature Publisher Guid |
guid |
false |
OctoSAM internal Guid of this software publisher entity |
| Version |
string |
true |
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 speical relevance such as Java |
| 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. |
| Help Link |
string |
false |
HelpLink Field from the Windows Installer Registry |
| Signature Install Date |
date |
true |
Date this software signature was installed on the particular machine |
| Signature File Last Write Time |
date |
false |
Last write time of the file of this signature |
| Signature Folder Last Write Time |
date |
false |
Last write time of the folder of this signature |
| Signature Last Usage |
date |
false |
Date this software signature was last used |
| Signature First Scan |
date |
false |
First scan of this signature on this machine |
| Signature Last Scan |
date |
false |
Last scan of this signature on this machine |
| 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 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 |
| Machine Name |
string |
false |
Machine name (computer name) |
| Machine |
string |
true |
Distinct machine name. Use Column Chooser to show partial values such as Name or Domain of machines |
| Machine Description |
string |
false |
Description attribute of the directory service or manually entered during offline scan |
| 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 |
| Virtual Machine |
bool |
false |
True if this is a virtual machine |
| Model |
string |
false |
Model of the Machine as defined in WMI |
| Network Address |
string |
false |
Network address, usually the IP number. |
| Network Mac Address |
string |
false |
MAC address of the main interface (corresponds to NetworkNetworkAddress |
| Operating System |
string |
true |
Operating System installed on this machine as reported by OctoSAM scanners |
| Operating System Server |
bool |
false |
True if this OS is a server version |
| Operating System Version |
string |
false |
Additional version information about the OS |
| Operating System Publisher |
string |
false |
Publisher of the OS. |
| Operating System Family |
string |
false |
A short name to identify different operating system families |
| Last Scan |
date |
true |
Date/Time this entity got scanned last |
| Last Found In Directory |
date |
false |
Time the object was last found in the directory service |
| Deleted In Directory |
bool |
false |
True, if directory check detects that the machine is no longer found in directory. |
| Deleted In Directory First Detected |
date |
false |
Date/Time the delete flag was set |
| Directory Path |
string |
false |
Path where the machine was found in the directory service. Usually an LDAP path. |
| Directory Container Path |
string |
false |
Path to the container of this object. Provided for grouping or export to other applications. |
| 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 |
string |
true |
User that is most frequently using this machine |
| Most Frequent User Displayname |
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 |
string |
false |
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 User Domain Name |
string |
true |
|
| 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. |
| LastUserDomainName |
string |
true |
Domainname of the last user that used this machine |