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.