SoftwareSignature (Internal)¶
OctoSAM Internal Query
Internal queries are advanced queries for analysis of the inner workings of the OctoSAM application. These queries are geared towards administrators with an in-depth knowledge of OctoSAM.
All rows and columns from the SoftwareSignature table.
Fields¶
| Name | Type | Visible | Description |
|---|---|---|---|
| ID | numeric | true | OctoSAM internal ID of this entity |
| MD5Hash | string | true | Reserved for future use. Unique Hash over multiple columns, used to speed up the import service and to discern software signatures in future versions. |
| Software Package ID | numeric | true | OctoSAM internal ID of this software package entity |
| Signature | string | true | Software signature as reported by the OctoSAM scanners |
| Dynamic | bool | true | Dynamic signatures do not appear on every scan. The absencence of this signature does not signify a software uninstall. |
| Raw Publisher | string | true | Publisher string as scanned from the system. See field 'Publisher' for normalized publisher |
| Version | string | true | Version Information from the MSI registry (if known) |
| Notes | string | true | Custom notes |
| Created | date | true | Date/Time this entity was created |
| Created GUID | guid | true | Unique id of the .scan file that created this object |
| Scan Signature | string | true | The Signature as reported by Octoscan2 (without Signature Rewriting) |
| Scan Hint | string | true | Octoscan can place additional information about found software signatures that can be used for rewriting |
| Custom Field1 | string | true | Custom Data - not used by OctoSAM Inventory |
| Custom Field2 | string | true | Custom Data - not used by OctoSAM Inventory |
| Last Modification | date | true | Date/Time this entity was last updated. In most cases, this is the time of the last import. In case of re-import of older scan files, LastModification can differ significantly from LastScan. |
| Comments | string | true | Comment field from the Windows installer registry, |
| Contact | string | true | Contact field from the Windows Installer Registry |
| Product Code | string | true | ProductCode from the Windows Installer Registry |
| Product Name | string | true | ProductName from either the Windows Installer Registry or from process version resource |
| Version Major | numeric | true | VersionMajor Field from the Windows installer fegistry |
| Version Minor | numeric | true | VersionMinor Field from the Windows installer registry |
| Help Link | string | true | HelpLink Field from the Windows Installer Registry |
| Url Info About | string | true | Hyperlink to package information |
| Url Update Info | string | true | UrlUpdateInfo Field from the Windows Installer Registry |
| System Component | bool | true | SystemComponent Flag from the Windows Installer Registry |
| Language | numeric | true | Language code from the Windows Installer Registry |
| Info | string | true | Info field from Windows Registry and Mac system_profiler |
| Res1 | string | true | Reserved for internal use of future versions |
| Res2 | string | true | Reserved for internal use of future versions |
| Path | string | true | Installation location of a software component |
| Architecture | string | true | Architecture field from the Windows Installer Registry or from process executable information |
| May Remain After Uninstall | bool | true | 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. |
| Rewritten | bool | true | True if the Signature field was rewritten by signature rewriting rules |
| Rewriting Rule Name | string | true | Name of the last rule that was applied at signature rewriting |
| Swid Signature | bool | true | True if the signature was generated from an SWID tag file |
| Software Publisher ID | numeric | true | OctoSAM internal ID of this software publisher entity |
| Junk | bool | true | This software category or signature is marked as 'Junk'. It should not have any influence on software licensing. |
| Reported To Central | date | true | For installations with central reporting of new signatures, timestamp when the signature was reported. |
| Virtualized | bool | true | True if a signature stems from a virtualization system such as App-V |
| Licensing Relevant | bool | true | True if the package or licensing type is considered relevant for licensing |
| Base Version | string | true | Signature version determined by per-product logic within OctoSAM for signatures where uniform versioning has a speical relevance such as Java |
| Analysis Extras | string | true | Holds extra data that is used internally by OctoSAM |
| Extra Data | string | true | Extra data for this object (JSON) |
| Installation Approved | bool | true | If true, installation of this signature is approved on all machines. |
| Installation Approved Changed | date | true | Date/Time the installation approval flag was last changed |
| Installation Approved Changed By | string | true | User that last changed the installation approval flag |
| Custom Field3 | string | true | Custom Data - not used by OctoSAM Inventory |
| Custom Field4 | string | true | Custom Data - not used by OctoSAM Inventory |
| Exact Version | string | true | Some scanners provide a detailed signature version for special signatures such as Java, where exact build version can be of interest. |
| Release Type | string | true | Some software such as Oracle Java is available in different release types. The values in this field are specific to the software or publisher. |
| Last Scan | date | true | Date/Time this entity got scanned last |
| Guid | guid | true | A unique ID that can be used to link to this object by external applications |
| Object State ID | numeric | true | Internal ID that references the ObjectState entity (Foreign Key) |
| 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 | 830490c6-9f28-42c3-86ce-671f44246065 | The internal id of the query. Must be unique |
| SupportsDesktop | true | If true, the query can be started from the OctoSAM Windows GUI |
| SupportsWeb | false | If true, the query can be started from the OctoSAM Web UI |