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.