Skip to content

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