HP Device Manager 4.6 - Database Schema Guide

Gateway-related tables
dm_gateway
This is the gateway table.
1. Table columns
Column name Type name Column size Nullable Primary key Description
gateway_id nvarchar 50 NO √ Gateway ID (use MAC address as default)
Active smallint 5 NO Whether the gateway is active or not:
0: inactive
1: active
2: broken
authentic smallint 5 NO Authentic type:
0: unknown
1: acknowledged
2: banned
found_date datetime 23 NO Gateway found date
gateway_name nvarchar 50 NO Gateway name
Ip nvarchar 50 NO Gateway IP
Mac nvarchar 50 NO Gateway MAC address
Mask nvarchar 50 NO Mask
netaddress nvarchar 50 NO Net address
os_type nvarchar 20 NO Operating system type
poll_interval nvarchar 50 NO Poll interval, by default null
update_date datetime 23 NO Update date
Version nvarchar 50 NO Version
2. Relevant UI
31