SoftwareHistory (System Machine Context)¶
OctoSAM Machine context 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 installed software history on this machine.
Software installation history shows all software packages that have been detected as installed or uninstalled on this machine, since the feature was introduced in OctoSAM 1.12.2. The list includes software packages that are currently installed as well as software packages that have been uninstalled.
The Installed column shows the installation date as it was recorded during the scan. OctoSAM Inventory uses multiple methods to determine the installation date of a software package, depending on the type of software package and the data available on the machine. Some installation dates are more accurate than others.
The Uninstalled column shows the uninstallation date as it was detected in OctoSAM. It is the date when OctoSAM first detected that the software package is no longer installed on the machine. Depending on the scan frequency and the method used to detect software installations, the uninstallation date may be more or less accurate.
This query can show SoftwarePackages that are no longer in the system, for example because they have been deleted from the catalog. In this case, the SoftwarePublisher and SoftwarePackage links will not be available.
Fields¶
| Name | Type | Visible | Description |
|---|---|---|---|
| Software Package Guid | guid | false | The GUID of the software package as it is/was defined in the software catalog. The software package may no longer exist in the OctoSAM database. |
| Software Package | string | true | Software package name from the OctoSAM software catalog |
| Software Package Link Guid | guid | false | |
| Software Package ID | numeric | false | OctoSAM internal ID of this software package entity |
| Software Publisher ID | numeric | false | OctoSAM internal ID of this software publisher entity |
| Software Publisher Link Guid | guid | false | |
| Software Publisher | string | true | Normalized software publisher from the OctoSAM catalog |
| Software Category | string | true | Software category name form the OctoSAM software catalog |
| Is Installed | bool | true | True if the software is currently installed on the machine |
| Install Date | date | true | Installation date of the software as detected on the machine. Multiple methods are used to determine the installation date, on Windows typically the MSI installation date is used. |
| Uninstall Date | date | true | Uninstall date as detected by OctoSAM. This is the date when OctoSAM detected that the software is no longer installed on the machine. |
| Created | date | false | Date/Time this record got created |
| Last Modification | date | false | Date/Time this record was last modified |
| Newest Static Signature | date | false | Date/Time of the newest static signature for this software installation |
| Newest Dynamic Signature | date | false | Date/Time of the newest dynamic signature for this software installation |
| Last Processed | date | false | Date/Time this record was last processed by OctoSAM services to detect changes |
| Usage Days | numeric | true | Number of days with detected usage. If no value, this means that either the package cannot be metered or we did not detect any usage. |
| 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 | 78eae3ea-cb91-4c65-b20a-8b4ddf2cf3ee | 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 |
| LastUpdate | 2026-01-24 17:49:21 | Last change to this document |
| Build | 1.12.2.93 | OctoSAM build that last changed this document |