HP Device Manager 4.6 - Database Schema Guide

Device-related tables
dm_devices
This is the devices table.
1. Table columns
Column name Type
name
Colu
mn
size
Nullable Primary
key
Foreign key Description
device_id nvarchar 50 NO √ dm_group_values.device_id;
dm_inv_display.device_id;
dm_inv_ewf.device_id;
dm_inv_ex_property.device_id;
dm_inv_hardware.device_id;
dm_inv_max_hotfix.device_id;
dm_inv_ms_hotfix.device_id;
dm_inv_nic.device_id;
dm_inv_partition.device_id;
dm_inv_software.device_id;
dm_inv_time.device_id;
Device ID
active nvarchar 6 NO Device active status:
0: off
1: on
2: broken
agent_version nvarchar 20 NO Agent version
device_name nvarchar 255 YES Device name
device_sn nvarchar 50 NO Device serial number
Ewf nvarchar 8 NO Write filter status:
0: disabled
1: enabled
2: N/A
first_contact smallint 5 NO First contact flag, will be reset to 1
by Factory Reset task to enable
First Contact rule again.
found_date datetime 23 NO The date that the device is found
inv_md5 nvarchar 50 YES MD5
Ip nvarchar 15 NO IP address
Mac nvarchar 17 NO MAC address
Mask nvarchar 15 NO Mask
master_id nvarchar 50 NO Gateway ID
Mode nvarchar 4 NO “pull” or “push”
net_addr nvarchar 15 NO Net address
os_type nvarchar 20 NO Operating system type
p1 nvarchar 50 NO The dynamic grouping value
attributes reported by device; can
be set from the HPDM Agent on
the device or on DHCP tag.
p2 nvarchar 50 NO
p3 nvarchar 50 NO
p4 nvarchar 50 NO
p5 nvarchar 50 NO
p6 nvarchar 50 NO
product_type nvarchar 100 NO Product type
product_versi nvarchar 100 NO Product version
9