| Machine ID |
string |
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 Guid |
guid |
false |
A unique ID that can be used to link to this machine object by external applications |
| sortind |
numeric |
false |
OctoSAM internal field used for default sorting |
| Software Category ID |
numeric |
false |
Internal ID that references the SoftwareCategory entity (Foreign Key) |
| 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 |
| Software Publisher |
string |
true |
Normalized software publisher from the OctoSAM catalog |
| Software Publisher ID |
numeric |
false |
Internal ID that references the SoftwarePublisher entity (Foreign Key) |
| Software Publisher Guid |
guid |
false |
OctoSAM internal Guid of this software publisher entity |
| Publisher Url |
string |
true |
Web Address of the software publisher |
| 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 |
| Software Licensing Type ID |
numeric |
false |
Internal ID that references the SoftwareLicensingType entity (Foreign Key) |
| Software Licensing Type |
string |
true |
Licensing type for this package as defined in the OctoSAM Inventory software catalog |
| 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. |
| Raw Publisher |
string |
false |
Publisher of the software (raw information as seen by the scan, see SoftwarePublisher table for normalized publisher information). |
| Scan Signature |
string |
false |
The Signature as reported by Octoscan2 (without Signature Rewriting) |
| 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 speical relevance such as Java |
| Licensing Relevant |
bool |
false |
For software packages with licensing type multiple, this can indicate a commercial signature. Requires additional detection Logic in OctoSAM. Used for example for Java Packages that have free and paid update levels. |
| MD5Hash |
string |
false |
Reserved for future use. Unique Hash over multiple columns, used to speed up the import service and to discern software signatures in future versions. |
| Signature Notes |
string |
false |
|
| Signature Created |
date |
false |
|
| Created GUID |
guid |
false |
Scan GUID that created this machine |
| Scan Hint |
string |
false |
Octoscan can place additional information about found software signatures that can be used for rewriting |
| Signature Custom Field1 |
string |
false |
|
| Signature Custom Field2 |
string |
false |
|
| Signature Last Modification |
date |
false |
|
| Signature Comments |
string |
false |
|
| Contact |
string |
false |
Contact field from the Windows Installer Registry |
| Product Code |
string |
false |
ProductCode from the Windows Installer Registry |
| Version Major |
numeric |
false |
VersionMajor Field from the Windows installer fegistry |
| Version Minor |
numeric |
false |
VersionMinor Field from the Windows installer registry |
| Help Link |
string |
false |
HelpLink Field from the Windows Installer Registry |
| Url Info About |
string |
false |
UrlInfoAbout Field from the Windows Installer Registry |
| Url Update Info |
string |
false |
UrlUpdateInfo Field from the Windows Installer Registry |
| System Component |
bool |
false |
SystemComponent Flag from the Windows Installer Registry |
| Language |
numeric |
false |
Language code from the Windows Installer Registry |
| Info |
string |
false |
Info field from Windows Registry and Mac system_profiler |
| Signature Res1 |
string |
false |
|
| Signature Res2 |
string |
false |
|
| Path |
string |
false |
Installation location of a software component |
| Architecture |
string |
false |
Architecture field from the Windows Installer Registry or from process executable information |
| May Remain After Uninstall |
bool |
false |
This can be used for static signatures that are left behind on product uninstall. For example some Adobe products leave the SWID tag file on uninstall. |
| Install Date |
date |
true |
Date/Time of installation if available. Not all packages provide an install date. |
| Install Location |
string |
false |
The location where a software package is installed on the system - if available |
| Install Source |
string |
false |
The source location of the installation package. For windows installer packages the path to the .msi file that was used for the installation. |
| File Last Write Time |
date |
false |
For file-based signatures contains the last modification date of the file |
| Folder Last Write Time |
date |
false |
For file-based signatures contains the last modification date of the parent folder of the file |
| Features |
string |
false |
Installation specific feature information |
| First Scan |
date |
false |
Date/Time of first scan of this machine |
| Last Scan |
date |
true |
Date/Time this entity got scanned last |
| Software Repackager ID |
numeric |
false |
Internal ID that references the SoftwareRepackager entity (Foreign Key) |
| Software Repackager |
string |
false |
|
| Software Repackager Info |
string |
false |
Repackager Info for supported Repackagers |
| Current Date Time |
date |
false |
Date and time the query was run. For reference if you use and save query results. |