HP Device Manager 4.5 - Database Schema Guide

21
Task-related tables
dm_tasks
This is the task table, which stores basic task-related information.
1. Table columns
Column Name
Type
Name
Column
Size
Nullable
Primary
Key
Description
action_type
smallint
5
YES
Inner column to identify template action type
ewf_policy
smallint
5
YES
Writer Filter Policy (default is 2):
0: If the Write Filter is on, send back failure information.
1: Execute regardless of Write Filter status.
2: If the Write Filter is on, reboot to clean overlay, execute
and commit, and then reboot for commitment to take effect.
hidden
nchar
1
YES
Deprecated column.
Default value is ‘1’ (don’t change this value)
History: there was a requirement that was needed to keep all
tasks, ‘1’ means visible, ‘0’ means invisible.
is_sequential
nchar
1
YES
Whether this task is sequential or not:
‘Y’: sequential
‘N’: no sequential
os_type nvarchar 50 NO OS type
task_id
nvarchar
50
NO
√
Task ID
task_name
nvarchar
50
YES
Task name
timeout
numeric
19
YES
Timeout of task
update_date
datetime
23
NO
Time will be updated when task status changes
user_id
nvarchar
50
NO
The user who creates the task
valid_time
float
53
YES
Valid time of task
2. Relevant UI