HP Device Manager 4.5 - Database Schema Guide

24
dm_tasklog
This is the task log table, which stores the task log information.
1. Table columns
Column Name
Type Name
Column Size
Nullable
Primary Key
Description
device_id
nvarchar
50
NO
√
Please refer to
dm_devices.device_id
sequence_num
numeric
19
NO
√
The sequence number of every log
(from 1to n)
subtask_id
nvarchar
50
NO
√
Sub-task ID
task_id
nvarchar
50
NO
√
Task ID
comment
ntext
1073741823
YES
The log comment
error_code
nvarchar
16
YES
Error code of log
error_detail
nvarchar
255
YES
Error detail information
update_date
datetime
23
NO
Update time
2. Relevant UI
task_id
update_date
comment
device_id