| sortind |
numeric |
false |
OctoSAM internal field used for default sorting |
| Software Package ID |
numeric |
false |
Internal ID that references the SoftwarePackage entity (Foreign Key) |
| Software Package Guid |
guid |
false |
OctoSAM internal Guid of this sofware package entity |
| Software Package |
string |
true |
Software package name from the OctoSAM software catalog |
| 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 |
| Software Signature |
string |
true |
Software signature as reported by the OctoSAM scanners |
| Raw Publisher |
string |
false |
Publisher of the software (raw information as seen by the scan, see SoftwarePublisher table for normalized publisher information). |
| Software Publisher Guid |
guid |
false |
OctoSAM internal Guid of this software publisher entity |
| Software Publisher ID |
numeric |
false |
Internal ID that references the SoftwarePublisher entity (Foreign Key) |
| Software Publisher |
string |
true |
Normalized software publisher from the OctoSAM catalog |
| 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 special 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. |
| Custom Field1 |
string |
false |
Custom Data - not used by OctoSAM Inventory |
| Custom Field2 |
string |
false |
Custom Data - not used by OctoSAM Inventory |
| Custom Field3 |
string |
false |
Custom Data - not used by OctoSAM Inventory |
| Custom Field4 |
string |
false |
Custom Data - not used by OctoSAM Inventory |
| Notes |
string |
false |
Custom notes |
| Ccp Basic Product Id |
numeric |
false |
|
| Installation Approved |
bool |
true |
If true, installation of this signature is approved on all machines |
| Installation Approved Changed |
date |
false |
Date/Time the installation approval flag was last changed |
| Installation Approved Changed By |
string |
false |
User that last changed the installation approval flag |
| Machines |
numeric |
true |
Number of machines where this signature is installed |
| Last Scan |
date |
true |
Date/Time this signature was last scanned on any machine |
| Current Date Time |
date |
false |
Date and time the query was run. For reference if you use and save query results. |