TaskExecutionStatus Table

FlexNet Manager Suite 2020 R1 (On-Premises)

The TaskExecutionStatus table stores progress data for rules and background tasks.

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

Database Column

Details

TaskExecutionStatusID

Type: integer. Key. Generated ID

Auto-generated task execution status ID

SessionUID

Type: unique identifier. Key

Unique task run identifier

TaskName

Type: text (max 255 characters). Key

The name of task.

ActivityTypeID

Type: integer. Key

Foreign key to the ActivityType table

DateStarted

Type: datetime. Nullable

Start date and time for a task.

DateCompleted

Type: datetime. Nullable

Completion date and time for a task.

EventTypeStatusID

Type: integer. Key

Foreign key to the EventTypeStatus table

BeaconRuleID

Type: integer. Key. Nullable

Foreign key to the BeaconRule table

ScheduledTriggerDateTick

Type: big integer. Key. Nullable

Executed date time in Tick.

BeaconID

Type: integer. Key. Nullable

Beacon where the task is executing.

BeaconPolicyRevision Number

Type: integer. Nullable

Beacon policy revision number

OperatorLogin

Type: text (max 255 characters). Nullable

Login of the operator who started task.

FlexNet Manager Suite (On-Premises)

2020 R1