InstalledSoftwareSignatures (System Machine Context)¶
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.
Show software signatues installed on this machine.
Fields¶
| Name | Type | Visible | Description |
|---|---|---|---|
| sortind | numeric | false | OctoSAM internal field used for default sorting |
| Software Category | string | true | Software category name form the OctoSAM software catalog |
| Software Package ID | numeric | false | Internal ID that references the SoftwarePackage entity (Foreign Key) |
| Software Package Guid | guid | false | GUID used for catalog updates. Stays the same for all OctoSAM defined software packages through the lifecycle of the package definition. Allows rename and delete of packages during catalog update.. Do not set if definig your own custom packages directly in the database. |
| Software Package | string | true | Software package name from the OctoSAM software catalog |
| Software Publisher | string | false | Normalized software publisher from the OctoSAM catalog |
| Software Publisher ID | numeric | false | Internal ID that references the SoftwarePublisher entity (Foreign Key) |
| Software Publisher Guid | guid | false | OctoSAM internal Guid of this software publisher entity |
| Software Publisher Url | string | false | |
| Software Signature ID | numeric | false | Internal ID that references the SoftwareSignature entity (Foreign Key) |
| Software Signature Guid | guid | false | A unique ID that can be used to link to this object by external applications |
| Software Licensing Type | string | true | Licensing type for this package as defined in the OctoSAM Inventory software catalog |
| Signature | string | true | Signature after signature rewriting process. Used to uniquely identify a software signature object. |
| Dynamic | bool | false | 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. |
| Raw Publisher | string | false | Publisher of the software (raw information as seen by the scan, see SoftwarePublisher table for normalized publisher information). |
| Scan Signature | string | false | The Signature as reported by Octoscan2 (without Signature Rewriting) |
| Version | string | false | 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 | true | True if the package or licensing type is considered relevant for licensing |
| Signature Approved | bool | false | |
| Signature Approved Changed | date | false | |
| Signature Approved Changed By | string | false | |
| MD5Hash | string | false | Reserved for future use. Unique Hash over multiple columns, used to speed up the import service and to discern software signatures in future versions. |
| Signature Notes | string | false | |
| Scan Hint | string | false | Octoscan can place additional information about found software signatures that can be used for rewriting |
| Signature Last Modification | date | false | |
| Signature Comments | string | false | |
| Contact | string | false | Contact field from the Windows Installer Registry |
| Product Code | string | false | ProductCode from the Windows Installer Registry |
| Version Major | numeric | false | VersionMajor Field from the Windows installer fegistry |
| Version Minor | numeric | false | VersionMinor Field from the Windows installer registry |
| Help Link | string | false | HelpLink Field from the Windows Installer Registry |
| Url Info About | string | false | UrlInfoAbout Field from the Windows Installer Registry |
| Url Update Info | string | false | UrlUpdateInfo Field from the Windows Installer Registry |
| System Component | bool | false | SystemComponent Flag from the Windows Installer Registry |
| Language | numeric | false | Language code from the Windows Installer Registry |
| Info | string | false | Info field from Windows Registry and Mac system_profiler |
| Path | string | false | Installation location of a software component |
| Architecture | string | false | Architecture field from the Windows Installer Registry or from process executable information |
| May Remain After Uninstall | bool | false | 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. |
| Install Date | date | true | Date/Time of installation if available. Not all packages provide an install date. |
| Install Location | string | false | The location where a software package is installed on the system - if available |
| Install Source | string | false | The source location of the installation package. For windows installer packages the path to the .msi file that was used for the installation. |
| Features | string | false | Installation specific feature information |
| Signature Installation Approved | bool | false | |
| Signature Installation Approved Changed | date | false | |
| Signature Installation Approved Changed By | string | false | |
| First Scan | date | false | Date/Time of first scan of this machine |
| Last Scan | date | true | Date/Time this entity got scanned last |
| 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 | 61383ffc-b5f1-47cb-b8bf-36ab1522b56a | 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 |