SoftwareSignaturesIndex (System)¶
OctoSAM System Query
This query is an integral part of the OctoSAM application. OctoSAM starts the query to display tabular data within the application. The query can only be started from within the intended application system context.
List all software signatures that are installed on at least one machine.
Fields¶
Name | Type | Visible | Description |
---|---|---|---|
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 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. |
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 |
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. |
Main entities referenced from this query¶
Query information¶
Property | Value | Description |
---|---|---|
Query Guid | f9dcbb42-a810-4df0-9e06-ab9d5a25b4c0 | The internal id of the query. Must be unique |
SupportsDesktop | true | If true, the query can be started from the OctoSAM Windows GUI |
SupportsWeb | true | If true, the query can be started from the OctoSAM Web UI |