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