device_wmialias


Description

This table contains reference information for all the WMI aliases a device has responded to. It is parent table that is partitioned over zone schema. A device can have as many records as received unique responses for each profiledata type in this table. One device can have zero to many records.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
zone_id int4 10 null
zone.id fk_device_wmi_alias_zone R

Zone Id of a device_wmialias record. It maps to zone.id
device_id int4 10 null
device.id fk_device_wmi_alias_device C

Id of a device this record belongs to. It maps to device.id
wmialias_id int4 10 null
wmialias.id fk_device_wmi_alias_alias C

Id of a wmialias this record belongs to. It maps to zone.wmialias.id
last_update timestamp 29,6 √ now()

The most recent time when a device has responded with given WMI alias. It gets updated with current timestamp everytime a device response for WMI discovery is received for an alias.

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_device_wmi_alias Primary key Asc/Asc device_id + wmialias_id

Relationships

Close relationships within degrees of separation