SoftwareOccurrence Table

The SoftwareOccurrence table contains the list (by computer and user) of applications that are installed. The applications may not have been installed through IT Asset Management. The information is obtained from managed devices from:

  • IT Asset Management

    packages cache

  • Add/Remove Programs registry entries
  • Microsoft Installer
  • ProductVersion resource strings in program files, if files are tracked
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 SoftwareOccurrence table

Database Column

Details

SoftwareOccurrenceID

Type: integer. Key. Generated ID

The id for the software occurrence. This is automatically generated by SQL Server.

ComputerID

Type: integer. Key

The computer on which the software was tracked. For user inventory, this is the computer that the user was logged on to at the time of the Generate Inventory event. This is a foreign key into the Computer table.

UserID

Type: integer. Key

User for whom the SoftwareVersion was installed. This is a foreign key to the User table.

SoftwareID

Type: integer. Key

The software that has been tracked. This is a foreign key to the SoftwareVersion table.

SoftwareDetailsID

Type: integer. Key

The details that have been tracked. This is a foreign key to the SoftwareDetails table.

Evidence

Type: text (max 32 characters). Nullable

An indication of how the software was determined to be on the managed device. The valid entries are:

  • msi
  • managesoft
  • uninstall
  • exehdr (for file tracking only)
  • dllhdr (for file tracking only)
PackagePathID

Type: integer. Key. Nullable

IT Asset Management

PackageFullName if known (not always!).

PolicyGUID

Type: binary (max 16 bytes). Nullable

IT Asset Management

Policy GUID if known.

InstallationDate

Type: datetime. Nullable

The date and time that the software was installed.