HP Device Manager 4.5 - Database Schema Guide

46
Rule- and Filter-related tables
dm_rule
This is the rule table.
1. Table columns
Column Name
Type Name
Column Size
Nullable
Primary Key
Description
rule_name
nvarchar
50
NO
√
Rule name
create_time datetime 23 NO Create time
creator
nvarchar
50
NO
The user ID that creates this rule
enable
int
10
NO
Rule is enabled or not:
0: disabled
1: enabled
rule_order
int
10
NO
Rule order to determine the execution
sequence: 1 ~n (priority High to Low)
task_id
nvarchar
50
NO
The task ID that is triggered by the rule. It
will be generated when a rule is created.
template_name
nvarchar
50
NO
Template name
trigger_type
int
10
NO
Trigger type:
1: first contact
2: startup
3: schedule
update_time
datetime
23
NO
Update time
version
int
10
NO
HPDM inner attribute, don’t modify it
filter_id
nvarchar
32
YES
Filter ID
schedule_id
nvarchar
50
YES
Schedule ID (if no schedule type, it will be
null)
os_type
nvarchar
50
NO
OS type
2. Relevant UI