This table contains information about the local Sector databases installed on the Domain. Each Sector database defined in the system is defined with one entry in this table.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| server_uuid | byte(16) | not null | UUID of an server instance |
| domain_uuid | byte(16) | not null | UUID of the domain |
| host_name | nvarchar(255) | with null | Server name |
| label | nvarchar(255) | with null | Display name |
| share_unc_path | nvarchar(127) | with null | Server share UNC Path |
| server_con_type | integer | not null | Server Type: -2=Floppy, -1=Offline, 0=Preconnect, 1=Autoconnect ..... for details see definition SECTORTYPEENUM |
| validation_interval_number | integer | with null | Server Validating Interval (Number of times), depending on Server design |
| validation_interval_status | integer | with null | Server Validating Interval (Every x seconds), depending on Server design |
| validation_interval_time | integer | with null | Server Validating Interval (Every x seconds), depending on Server design |
| validation_interval_date | integer | with null | |
| description | nvarchar(255) | with null | User entered description about the server |
| dis_hw_uuid | byte(16) | with null | Global uuid, use a common way to generate them |
| old_flg | integer | with null | 1 = it's an old SD Server
2 = it's and old Sector Server
if it's an old server there will be no entry in the server_component tabel |
| creation_user | nvarchar(255) | with null | Database user or component/process that created the record |
| creation_date | integer | with null | Creation date/Time |
| last_update_user | nvarchar(255) | with null | Database user or component/process that updated the record |
| last_update_date | integer | with null | Last Change Date/Time |
| version_number | integer | with null | Last version number |
| auto_rep_version | date | with null | Replication version information |
Product Name: Unicenter Desktop and Server Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| server_uuid | usd_v_sserver_clients ca_agent_component |
server_uuid |
| server_uuid | ca_agent | server_uuid |
| server_uuid | ca_server_queue | server_uuid |
| server_uuid | ca_server_push_status | server_uuid |
| server_uuid | ca_server_component | server_uuid |