HP Device Manager 4.6 - Database Schema Guide

Table Of Contents

dm_device_subtasks

This is the device subtasks table, which stores a device’s related tasks.

1. Table columns

Column name Type name Column size Nullable Primary key Description

task_id varchar 50 NO √

subtask_id varchar 50 NO √

device_id varchar 50 NO √

start_time datetime 23 NO

end_time datetime 23 NO

status varchar 16 YES It contains one of the following values: ready, waiting,

sending, processing, success, failure, waitForAgent,

processPercent, pause, waiting, chaos, unretrieved,

Operational, Deleting, Deleted, Canceling, Canceled.

visible char 1 YES

error_code varchar 20 YES

update_date datetime 23 NO

2. Relevant UI