A discovered device that is supported by WSM. Each device has a corresponding entry in Unicenter NSM WV Tables
| Column Name | Column Datatype | Column Null Option | Column Comment |
| device_id | byte(16) | not null | A unique id for the device |
| model_uuid | byte(16) | with null | A unique id for the device type |
| asset_source_uuid | byte(16) | not null | FK to asset_source table. This key is created when we call
the asset registration api. For all discovered devices that
are added by us we will link with the asset_source table
May be the same as the device_id |
| hostname | nvarchar(255) | with null | |
| ipaddress | nvarchar(255) | with null | |
| macaddress | nvarchar(255) | with null | |
| x_coordinate | float | with null | The x_coordinate |
| y_coordinate | float | with null | The ycoordinate |
| z_coordinate | float | with null | |
| last_seen | integer | not null | The time the device was last seen |
| wv_uuid | byte(16) | with null | This is the wv uuid for the object. We use this to ensure that we have a direct mapping to WorldView. We have chosen not to use the asset_source id for performance reasons. |
| status_id | integer | not null | The status id |
Product Name: Unicenter Wireless Site Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| device_id | wsm_configuration_history | device_id |
| device_id | wsm_agent | device_id |
| device_id | wsm_link_firmware_to_device | device_id |
| device_id | wsm_dc_val_8hr | device_id |
| device_id | wsm_dc_val_5min | device_id |
| device_id | wsm_dc_val_30min | device_id |
| device_id | wsm_dc_val_1year | device_id |
| device_id | wsm_dc_val_1week | device_id |
| device_id | wsm_dc_val_1mnth | device_id |
| device_id | wsm_dc_val_1min | device_id |
| device_id | wsm_dc_val_1hr | device_id |
| device_id | wsm_dc_val_1day | device_id |
| device_id | wsm_link_config_to_device | device_id |
| device_id | wsm_events | associated_device_id |
| device_id | wsm_events | source_device_id |
| device_id | wsm_engine | device_id |
| device_id | wsm_device_gui_attributes | device_id |
| device_id | wsm_device_attribute | device_id |