Activity Table

FlexNet Manager Suite 2020 R1 (On-Premises)

The Activity table stores errors and events processed by the beacon, devices, rules etc.

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 Activity table

Database Column

Details

ActivityID

Type: integer. Key. Generated ID

Synthetic key for this table.

SourceTypeID

Type: integer

The source type ID such as Beacon, External and so on

SourceTypeName

Type: text (max 256 characters)

The source type name such as Beacon, External and so on

ActivityTypeID

Type: integer. Key

Foreign key to the ActivityType table.

ActivityUID

Type: unique identifier. Key

UID to uniquely identify the activity.

DateCreated

Type: datetime

Time that the activity is created in the database.

FlexNet Manager Suite (On-Premises)

2020 R1