Skip to content

SoftwareSignature

A software signature is a unique pattern detected by software scan, like a fingerprint that a particular software leaves on machines.

erDiagram
    ObjectState ||--o{ SoftwareSignature : "ObjectStateID"
    SoftwarePackage ||--o{ SoftwareSignature : "SoftwarePackageID"
    SoftwarePublisher ||--o{ SoftwareSignature : "SoftwarePublisherID"
    SoftwareSignature ||--o{ MachineSoftwareSignature : "SoftwareSignatureID"
    SoftwareSignature ||--o{ MachineUserSoftwareSignature : "SoftwareSignatureID"
    SoftwareSignature ||--o{ SoftwareCatalogConflict : "SoftwareSignatureID"
    SoftwareSignature ||--o{ UsageDetail : "SoftwareSignatureID"

Fields

Field Type Description
AnalysisExtras xml Holds extra data that is used internally by OctoSAM
Architecture string Architecture field from the Windows Installer Registry or from process executable information
BaseVersion string Signature version determined by per-product logic within OctoSAM for signatures where uniform versioning has a special relevance such as Java
CcpBasicProductId numeric Reference to the basic product ID in the CCP system
CcpLanguageId numeric Reference to the language ID in the CCP system
CcpNormalizedSignature string Normalized signature value in the CCP system
CcpPlatformId numeric Reference to the platform ID in the CCP system
CcpSha1 varbinary SHA-1 hash value in the CCP system
Comments string Comment field from the Windows installer registry
Contact string Contact field from the Windows Installer Registry
Created datetime Date/Time this object was created
CreatedGUID guid Scan GUID that created this Software Signature
CustomField1 string Custom Data - not used by OctoSAM Inventory
CustomField2 string Custom Data - not used by OctoSAM Inventory
CustomField3 string Custom Data - not used by OctoSAM Inventory
CustomField4 string Custom Data - not used by OctoSAM Inventory
Dynamic boolean A dynamic signature is a signature that is not present on every scan. For example, information about running processes. Dynamic signature relations to machines are not immediately removed if not found in a .single scan file.
ExactVersion string Some scanners provide a detailed signature version for special signatures such as Java, where exact build version can be of interest.
ExtraData string Extra data for this software signature that is used internally by OctoSAM
Filename string Filename of the software component
Guid guid A unique ID that can be used to link to this object by external applications
HelpLink string HelpLink Field from the Windows Installer Registry
ID numeric Internal ID for the SoftwareSignature entity (Primary Key)
ID numeric Internal ID for the SoftwareSignature entity (Primary Key)
Info string Info field from Windows Registry and Mac system_profiler
InstallationApproved boolean If true, installation of this signature is approved on all machines
InstallationApprovedChanged datetime Date/Time the installation approval flag was last changed
InstallationApprovedChangedBy string User that last changed the installation approval flag
Junk boolean True if the signature is considered junk by junk filter rules
Language numeric Language code from the Windows Installer Registry
LastModification datetime Date/Time this Signature record was last modified through the OctoSAM Inventory UI
LastScan datetime Date/Time this signature was last scanned on any machine
LicensingRelevant boolean 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.
MayRemainAfterUninstall boolean This can be used for static signatures that are left behind on product uninstall. For example, some Adobe products leave the SWID tag file on uninstall.
MD5Hash string Reserved for future use. Unique Hash over multiple columns, used to speed up the import service and to discern software signatures in future versions.
Notes string Custom notes
ObjectStateID numeric Internal ID that references the ObjectState entity (Foreign Key)
Path string Installation location of a software component
ProductCode string ProductCode from the Windows Installer Registry
ProductName string ProductName from either the Windows Installer Registry or from process version resource
RawPublisher string Publisher of the software (raw information as seen by the scan, see SoftwarePublisher table for normalized publisher information).
ReleaseType string Some software such as Oracle Java is available in different release types. The values in this field are specific to the software or publisher.
ReportedToCentral datetime For installations with central reporting of new signatures, timestamp when the signature was reported.
Res1 string Reserved for internal use of future versions
Res2 string Reserved for internal use of future versions
RewritingRuleName string Name of the last rule that was applied at signature rewriting
Rewritten boolean True if the Signature field was rewritten by signature rewriting rules
ScanHint string Octoscan can place additional information about found software signatures that can be used for rewriting
ScanSignature string The Signature as reported by Octoscan2 (without Signature Rewriting)
Signature string Signature after signature rewriting process. Used to uniquely identify a software signature object.
SoftwarePackageID numeric Internal ID that references the SoftwarePackage entity (Foreign Key)
SoftwarePublisherID numeric Internal ID that references the SoftwarePublisher entity (Foreign Key)
SwidSignature boolean True if the signature was generated from an SWID tag file
SystemComponent boolean SystemComponent Flag from the Windows Installer Registry
UrlInfoAbout string UrlInfoAbout Field from the Windows Installer Registry
UrlUpdateInfo string UrlUpdateInfo Field from the Windows Installer Registry
Version string Version Information from the MSI registry (if known)
VersionMajor numeric VersionMajor Field from the Windows installer registry
VersionMinor numeric VersionMinor Field from the Windows installer registry
Virtualized boolean True if a signature stems from a virtualization system such as App-V

References

Column Name Referenced Table Description
ObjectStateID ObjectState Object states for various OctoSAM entities
SoftwarePackageID SoftwarePackage A software package defines a logical software entity. A software package can own 0 to n software signatures.
SoftwarePublisherID SoftwarePublisher Normalized publisher information from the catalog

Referenced by

Table Column Name Description
MachineSoftwareSignature SoftwareSignatureID M:n relation between machines and software signatures
MachineUserSoftwareSignature SoftwareSignatureID M:n relation between MachineUser and SoftwareSignature for per user signatures
SoftwareCatalogConflict SoftwareSignatureID Contains conflicts detected by the software catalog update mechanism
UsageDetail SoftwareSignatureID Holds detailed usage information as imported from octoscan scan files. This table should usually not be referenced directly by reports and queries. Use the consolidated SoftwarePackageUsageDetail table instead.