HP Device Manager 4.5 - Database Schema Guide

9
Device-related tables
dm_devices
This is the devices table.
1. Table columns
Column Name
Type
Name
Column
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
100
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 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
Master ID
Mode
nvarchar
4
NO
“pull” or “push”
net_addr
nvarchar
15
NO
Net address
os_type
nvarchar
20
NO
OS type
p1
nvarchar
50
NO
The dynamic grouping value
attributes reported by device;
could be set from the Agent GUI
on device or on DHCP tag.
p2 nvarchar 50 NO
p3
nvarchar
50
NO
p4
nvarchar
50
NO
p5
nvarchar
50
NO