InstallationHistory Table

The action performed on the package, normally “install” or “uninstall”. In the event that installation event logs were lost, entries may be reconstructed here from data in inventory (cache tracking). Such entries may be less reliable (in particular the recorded date will be the date of the inventory) and will have one of the following Action values:

“inv insert”
“inv delete”
“inv update”

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.

Table 1. Database columns for `InstallationHistory` table
Database Column	Details
`ComputerID`	Type: integer. Key The computer that the installation event occurred on. This is a foreign key into the `Computer` table.
`UserID`	Type: integer. Key The user associated with the installation event. This is a foreign key into the `User` table. If the `UserID` is 1 then the installation event occurred as part of computer policy. Otherwise, the installation event occurred as part of user policy.
`PackageVersionID`	Type: integer. Key The id for the `PackageVersion` installed
`Reported`	Type: datetime. Key The date and time that the installation event occurred.
`Action`	Type: text (max 10 characters) The action performed on the package. This value can be either, install or uninstall.
`Received`	Type: datetime. Nullable The date and time that the installation status event was received into the database.
`FailReasonID`	Type: integer. Nullable A reference to the reason for the installation failure. If the installation succeeded then this value is NULL.
`Result`	Type: text (max 16 characters). Nullable The result of the package installation. Possible values are either success or failure.