HP Device Manager 4.5 - Database Schema Guide

13
dm_inv_hardware
This is the inventory hardware table.
1. Table columns
Column Name
Type Name
Column Size
Nullable
Primary Key
Description
device_id
nvarchar
50
NO
√
filesystem
nvarchar
50
YES
free_disk
nvarchar
255
YES
free_mem
nvarchar
100
YES
frequency
nvarchar
100
YES
ispxe
tinyint
3
YES
iswol
tinyint
3
YES
model
nvarchar
100
YES
processor_type
nvarchar
100
YES
processor_vendor
nvarchar
100
YES
serial_no
nvarchar
100
YES
total_disk
nvarchar
255
YES
total_mem
nvarchar
100
YES
update_date
datetime
23
NO
2. Relevant UI