| Software Package Id |
numeric |
false |
OctoSAM internal ID of this software package entity |
| 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 Id |
numeric |
false |
OctoSAM internal ID of this software publisher entity |
| Software Publisher Guid |
guid |
false |
OctoSAM internal Guid of this software publisher entity |
| Software Publisher |
string |
true |
Normalized software publisher from the OctoSAM catalog |
| Software Licensing Type |
string |
true |
Licensing type for this package as defined in the OctoSAM Inventory software catalog |
| Package Licensing Relevant |
bool |
false |
True if the package or licensing type is considered relevant for licensing |
| Software Signature Id |
numeric |
false |
OctoSAM internal ID of this software signature entity |
| Software Signature Guid |
guid |
false |
A unique ID that can be used to link to this object by external applications |
| Version Licensing Relevant |
bool |
true |
Oracle License is required for this update/version/build |
| Signature |
string |
true |
Signature after signature rewriting process. Used to uniquely identify a software signature object. |
| Path |
string |
false |
Installation location of a software component |
| Machines |
numeric |
true |
|
| Package Machines |
numeric |
true |
|
| Process Signature |
string |
false |
|
| Process Usage |
numeric |
true |
Totel usage of this process on all machines during the selected timeframe |
| Signature Publisher |
string |
true |
|
| Version |
string |
true |
Version Information from the MSI registry (if known) |
| Base Version |
string |
true |
Consolidated version number used to determine builds and releases that require an Oracle license |
| Created |
date |
true |
Date/Time this entity was created |
| Scan Signature |
string |
false |
The Signature as reported by Octoscan2 (without Signature Rewriting) |
| Scan Hint |
string |
true |
Octoscan can place additional information about found software signatures that can be used for rewriting |
| Architecture |
string |
true |
Architecture field from the Windows Installer Registry or from process executable information |
| Lifecycle Long Term Support |
bool |
true |
For package specific software life cycle: true if a long term support release |
| Lifcycle Expired |
bool |
true |
|
| Lifecycle Start Date |
date |
true |
For package specific software life cycle: life cycle start date, |
| Lifecycle Mainstream End Date |
date |
true |
For package specific software life cycle: mainstream support end date |
| Lifecycle Extended End Date |
date |
true |
For package specific software life cycle: extended support end date |
| Current Date Time |
date |
false |
Date and time the query was run. For reference if you use and save query results. |