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 FlexNet Manager Suite. The information is obtained from managed devices from:

  • FlexNet Manager Suite

    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



Type: integer. Key. Generated ID

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


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.


Type: integer. Key

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


Type: integer. Key

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


Type: integer. Key

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


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)

Type: integer. Key. Nullable

FlexNet Manager Suite

PackageFullName if known (not always!).


Type: binary (max 16 bytes). Nullable

FlexNet Manager Suite

Policy GUID if known.


Type: datetime. Nullable

The date and time that the software was installed.