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	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 FlexNet Manager Suite `PackageFullName` if known (not always!).
`PolicyGUID`	Type: binary (max 16 bytes). Nullable FlexNet Manager Suite `Policy` GUID if known.
`InstallationDate`	Type: datetime. Nullable The date and time that the software was installed.