wsm_engine

This table is populated by a manager as it starts up. The following actions will take place. 1) The manager will create an entry in the asset_source table using registration api 2) It will insert a row into this table 3) Generate a DBEvent

The data that is stored in this table will be used as a master reference for many other tables in the system

Column Name Column Datatype Column Null Option Column Comment
manager_uuid byte(16) not null The uuid of the manager
create_date date not null The date entry was created
last_start_date date with null DateTime service was started
last_stop_date date with null Last time service was stopped
creation_user nvarchar(64) with null User that created entry
update_user nvarchar(64) with null User/Process that last updated table
device_id byte(16) not null A unique id for the device
time_zone_code varchar(8) with null Time zone code is the code for a particular time zone, Eg- EST, PST etc
locale_code varchar(4) with null Locale code is the code for particular locale, Eg- us_en for united states english, cn_zh for simplified chinese

Identifiers what locale the machine is running

status_id integer not null The status id
config_profile_uuid byte(16) with null The uuid of the configuration Profile

Product Name: Unicenter Wireless Site Management

Table Type: Table

Relationships:

Primary Key Related Table Related Column
manager_uuid wsm_agent manager_uuid
manager_uuid wsm_user_gui_configuration manager_uuid
manager_uuid wsm_task_list manager_uuid
manager_uuid wsm_subnets manager_uuid
manager_uuid wsm_location manager_uuid
manager_uuid wsm_global_gui_configuration manager_uuid


Copyright © 2006 CA. All rights reserved.