| Software Signature ID |
numeric |
false |
Internal ID for the SoftwareSignature entity (Primary 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. |
| 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 |
| Release Type |
string |
true |
Some software such as Oracle Java is available in different release types. The values in this field are specific to the software or publisher. |
| Signature Approved |
bool |
true |
This signature is directly (at signature level) approved for installation |
| Signature Approved Changed |
date |
false |
|
| Signature Approved Changed By |
string |
false |
|
| Machines |
numeric |
true |
|
| Approved Signature Installations |
numeric |
false |
Number of machines where this signature is approved for installation |
| Approved Package Installations |
numeric |
true |
Number of machines where the package that contains the signature is approved for installation |
| Signature Custom Field1 |
string |
false |
|
| Signature Custom Field2 |
string |
false |
|
| Signature Custom Field3 |
string |
false |
|
| Signature Custom Field4 |
string |
false |
|
| Last Scan |
date |
true |
Date/Time this entity got scanned last |
| 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 |
| Software Publisher |
string |
true |
Normalized software publisher from the OctoSAM 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 |
| Package Custom Field1 |
string |
false |
CustomField1 for the SoftwarePackge. Not used by OctoSAM Inventory. |
| Package Custom Field2 |
string |
false |
CustomField2 for the SoftwarePackge. Not used by OctoSAM Inventory. |
| Package Custom Field3 |
string |
false |
CustomField3 for the SoftwarePackge. Not used by OctoSAM Inventory. |
| Package Custom Field4 |
string |
false |
CustomField4 for the SoftwarePackge. 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. |