DiscoveredDeviceTaskStatusHistory Table

Records any task status information for DiscoveredDevice.

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

Database Column

Details

DiscoveredDeviceTask StatusHistoryID

Type: integer. Key. Generated ID

The ID of the discovered device task.

DeviceID

Type: integer. Key

Device identity number.

TaskTypeID

Type: integer. Key

The type of task which was run on the device.

SessionUID

Type: unique identifier. Key

An identifier TaskExecutionStatus table

BeaconUID

Type: unique identifier. Key

The inventory beacon that has run the task.

BeaconRuleID

Type: integer. Key. Nullable

Rule that executed this task.

Success

Type: boolean. Key

Status of the task. It can be Success OR Failed

Credential

Type: text (max 256 characters). Nullable

The credential name for the task performed.

Status

Type: text (max 256 characters)

The status code of task.

DetailedStatus

Type: text. Nullable

The detailed error status.

StartDateTime

Type: datetime

Date and time the task was started.

BeaconPolicyRevision Number

Type: integer. Nullable

The beacon policy revision number where rule is found

IsSkipTask

Type: boolean. Key

Determines whether the task status is a skip task

IsDiscoveryTask

Type: boolean. Key

Determines whether the task status is a discovery task