Stores hardware definition attributes. Attributes that uniquely define and describe a hardware unit discovered and collected by Unicenter Asset Management.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| hwuuid | byte(16) | not null | Unique identifier for related hardware definition |
| hwdom | nvarchar(128) | not null | Hardware domain |
| hwname | nvarchar(128) | not null | Hardware UAM unit name (host name) |
| hwsn | nvarchar(128) | not null | Hardware serial number |
| hwtype | nvarchar(128) | not null | Hardware type as listed in UAM (i.e., "Notebook", "Desktop") |
| hwmfgr | nvarchar(128) | not null | Hardware manufacturer |
| hwmodel | nvarchar(128) | not null | Hardware model |
| hwmem | integer | not null | Hardware total physical memory |
| hwbiosmfgr | nvarchar(128) | not null | Hardware BIOS manufacturer |
| hwbiosver | nvarchar(128) | not null | Hardware BIOS version |
| hwbiosdate | nvarchar(128) | not null | Hardware BIOS date |
| hwprocmfgr | nvarchar(128) | not null | Hardware processor manufacturer |
| hwprocmodel | nvarchar(128) | not null | Hardware processor model (i.e., "Intel Mobile Pentium III-M") |
| hwproctype | nvarchar(128) | not null | Hardware processor type (i.e., "P6") |
| hwproccount | integer | not null | Hardware processor count |
| hwprocspeed | integer | not null | Hardware processor speed |
| domainid | integer | not null | Source UAM internal DOMAINID value |
| unitid | integer | not null | Source UAM internal UNITID value |
Product Name: Unicenter Asset Intelligence
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| hwuuid | ai_hwdef_lscandate_kpi | hwuuid |
| hwuuid | ai_hwdef_login_maxscan_rel | hwuuid |
| hwuuid | ai_hwdef_login_lscandate_rel | hwuuid |
| hwuuid | ai_hwdef_login_all_rel | hwuuid |
| hwuuid | ai_hfdef_hwdef_rel | hwuuid |
| hwuuid | ai_fsdef_prop | hwuuid |
| hwuuid | ai_fddef_prop | hwuuid |
| hwuuid | ai_swdef_hwdef_rel | hwuuid |
| hwuuid | ai_pubdef_hwdef_rel | hwuuid |
| hwuuid | ai_osdef_hwdef_rel | hwuuid |
| hwuuid | ai_ipdef_prop | hwuuid |
| hwuuid | ai_hwdef_osinstdate_kpi | hwuuid |
| hwuuid | ai_hwdef_mac_kpi | hwuuid |