HP Device Manager 4.6 - Database Schema Guide

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 generated when a rule is created
and then triggered by that rule
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 Operating system type
2. Relevant UI
43