HP Device Manager 4.6 - Database Schema Guide

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 the 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, restart to a clean overlay, execute, and
commit, and then restart for commitment to take effect.
hidden nchar 1 YES Deprecated column.
Default value is 1(do not change this value)
History: 1 means visible and 0 means invisible.
is_sequential nchar 1 YES Whether a task is sequential:
Y: sequential
N: not sequential
os_type nvarchar 50 NO Operating system 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
21