SoftwareSignature¶
A software signature is a unique pattern detected by software scan, like a fingerprint that a particular software leaves on on machines.
Fields¶
| Field | Type | Description |
|---|---|---|
| AnalysisExtras | xml | Holds extra data that is used internally by OctoSAM |
| Architecture | nvarchar | Architecture field from the Windows Installer Registry or from process executable information |
| BaseVersion | nvarchar | Signature version determined by per-product logic within OctoSAM for signatures where uniform versioning has a speical relevance such as Java |
| Comments | nvarchar | Comment field from the Windows installer registry, |
| Contact | nvarchar | Contact field from the Windows Installer Registry |
| Created | datetime2 | Time this object was created |
| CreatedGUID | uniqueidentifier | Scan GUID that created this Software Signature |
| CustomField1 | nvarchar | Custom Data - not used by OctoSAM Inventory |
| CustomField2 | nvarchar | Custom Data - not used by OctoSAM Inventory |
| CustomField3 | nvarchar | Custom Data - not used by OctoSAM Inventory |
| CustomField4 | nvarchar | Custom Data - not used by OctoSAM Inventory |
| Dynamic | bit | 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 | nvarchar | Some scanners provide a detailed signature version for special signatures such as Java, where exact build version can be of interest. |
| ExtraData | nvarchar | Extra data for this software signature that is used internally by OctoSAM |
| Guid | uniqueidentifier | A unique ID that can be used to link to this object by external applications |
| HelpLink | nvarchar | HelpLink Field from the Windows Installer Registry |
| ID | bigint | Internal ID for the SoftwareSignature entity (Primary Key) |
| ID | bigint | Internal ID for the SoftwareSignature entity (Primary Key) |
| Info | nvarchar | Info field from Windows Registry and Mac system_profiler |
| InstallationApproved | bit | If true, installation of this signature is approved on all machines. |
| InstallationApprovedChanged | datetime2 | Date/Time the installation approval flag was last changed |
| InstallationApprovedChangedBy | nvarchar | User that last changed the installation approval flag |
| Junk | bit | True if the signature is considered junk by junk filter rules |
| Language | bigint | Language code from the Windows Installer Registry |
| LastModification | datetime2 | Date/Time this Signature record was last modified through the OctoSAM Inventory UI |
| LastScan | datetime2 | Date/Time this signature was last scanned on any machine |
| LicensingRelevant | bit | 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 | bit | 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 | char | 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 | nvarchar | Custom notes |
| ObjectStateID | bigint | Internal ID that references the ObjectState entity (Foreign Key) |
| Path | nvarchar | Installation location of a software component |
| ProductCode | nvarchar | ProductCode from the Windows Installer Registry |
| ProductName | nvarchar | ProductName from either the Windows Installer Registry or from process version resource |
| RawPublisher | nvarchar | Publisher of the software (raw information as seen by the scan, see SoftwarePublisher table for normalized publisher information). |
| ReleaseType | nvarchar | 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 | datetime2 | For installations with central reporting of new signatures, timestamp when the signature was reported. |
| Res1 | nvarchar | Reserved for internal use of future versions |
| Res2 | nvarchar | Reserved for internal use of future versions |
| RewritingRuleName | nvarchar | Name of the last rule that was applied at signature rewriting |
| Rewritten | bit | True if the Signature field was rewritten by signature rewriting rules |
| ScanHint | nvarchar | Octoscan can place additional information about found software signatures that can be used for rewriting |
| ScanSignature | nvarchar | The Signature as reported by Octoscan2 (without Signature Rewriting) |
| Signature | nvarchar | Signature after signature rewriting process. Used to uniquely identify a software signature object. |
| SoftwarePackageID | bigint | Internal ID that references the SoftwarePackage entity (Foreign Key) |
| SoftwarePublisherID | bigint | Internal ID that references the SoftwarePublisher entity (Foreign Key) |
| SwidSignature | bit | True if the signature was generated from an SWID tag file |
| SystemComponent | bit | SystemComponent Flag from the Windows Installer Registry |
| UrlInfoAbout | nvarchar | UrlInfoAbout Field from the Windows Installer Registry |
| UrlUpdateInfo | nvarchar | UrlUpdateInfo Field from the Windows Installer Registry |
| Version | nvarchar | Version Information from the MSI registry (if known) |
| VersionMajor | bigint | VersionMajor Field from the Windows installer fegistry |
| VersionMinor | bigint | VersionMinor Field from the Windows installer registry |
| Virtualized | bit | True if a signature stems from a virtualization system such as App-V |