MachinesSoftwareHistory (System Software Package Context)¶
OctoSAM Software Package 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 installation history of this software package on machines.
Software installation history shows all machines where this software package has been detected as installed or uninstalled since the feature was introduced in OctoSAM 1.12.2. The list includes machines where this software package is currently installed as well as where it has 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 Machines that are no longer in the system, for example because they have been deleted from the database. In this case, the Machine link will not be available.
Fields¶
| Name | Type | Visible | Description |
|---|---|---|---|
| Machine Guid | guid | false | The machine GUID of the machine where the software is/was installed. The machine may no longer exist in the OctoSAM database. |
| Machine Link Guid | guid | false | |
| Machine Link ID | numeric | false | |
| Organization ID | numeric | false | OctoSAM internal ID of this Organization entity |
| Organization | string | true | Name of the organization this entity is mapped to |
| Machine | string | true | Distinct machine name. Use Column Chooser to show partial values such as Name or Domain of machines |
| Operating System Family | string | false | A short identifier of the operating system family |
| Operating System Server | bool | false | |
| Operating System | string | true | Operating System installed on this machine as reported by OctoSAM scanners |
| Directory Path | string | false | Path to this user or machine object in Active Directoy |
| Directory Container Path | string | false | Path to the container of this user or machine object in Active Directory |
| Manufacturer | string | false | Normalized manufacturer information. See field 'Raw Manufacturer' for scanned information |
| Model | string | true | |
| 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 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 | 1e103472-591a-458c-bd81-c23fd0b82852 | 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:56:20 | Last change to this document |
| Build | 1.12.2.93 | OctoSAM build that last changed this document |