Installation Table

The Installation table contains the latest installation status of each package for each user and computer. Success or failure of installations is recorded. When a package is uninstalled, its installation status record is removed from the table. When an installation is successful, the successful installation status record replaces any earlier failure status records. Once an installation is successful, the Installation table retains the successful installation status record even if there are subsequent failed installation attempts. If there have been any subsequent failed installations, the latest of these failure records is also be retained. For example, if an installation fails, and then succeeds on a subsequent attempt, only the successful status is recorded. If an installation succeeds, but a later installation attempt fails, then both the success and failure status records are stored. All other installations are added to the InstallationHistory table as new status information is generated.

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 `Installation` 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 (system user), then the installation event occurred as part of computer policy. Otherwise, the installation event occurred as part of user policy.
`PackageVersionID`	Type: integer. Key Package version that was installed
`OrganizationID`	Type: integer. Key The organizational unit of the user or computer associated with the installation event. This is a foreign key into the `Organization` table. This column is included in the table for clustering purposes. The value of OUID could be determined by looking up the `User` or `Computer` table. If the `UserID` is 1 (system user), OUID represents the organizational unit of the computer that the installation event occurred on. Otherwise, it represents the organizational unit of the user associated with the installation event.
`Action`	Type: text (max 10 characters) The action performed on the package. This is currently set to “install”. In future, “upgrade”, “update” and “selfheal” may be added.
`Reported`	Type: datetime. Nullable The date and time that the installation event occurred.
`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 success or failure.