|
srv_env_hw
Detailed information on hardware on stations of the neighbor Server.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
reference UUID
|
type
|
INTEGER NOT NULL
|
device type, see st-db-env-hw
|
name
|
INTEGER NOT NULL
|
device name, reference to `env_strings`
|
vendor
|
INTEGER NOT NULL
|
device vendor, reference to `env_strings`
|
info1
|
NUMERIC(11) NOT NULL
|
device information, line #1
|
info2
|
NUMERIC(11) NOT NULL
|
device information, line #2
|
Table indexes
Index name
|
Index type
|
Fields list
|
srv_env_hw_0001
|
simple table index
clustering index
|
id
|
Table references
Field name
|
Direction
|
Referenced table field
|
name
|
↔
|
env_strings.id
|
vendor
|
↔
|
env_strings.id
|
srv_env_kb
Detailed information on Windows OS updates installed on stations of the neighbor Server.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
reference UUID
|
name
|
INTEGER NOT NULL
|
Windows update name, reference to `env_strings`
|
Table indexes
Index name
|
Index type
|
Fields list
|
srv_env_kb_0001
|
simple table index
clustering index
|
id
|
Table references
Field name
|
Direction
|
Referenced table field
|
name
|
↔
|
env_strings.id
|
srv_env_meta
General information on hardware and software on stations of the neighbor Server.
Table fields
Field name
|
Field type
|
Description
|
osid
|
VARCHAR(36) NOT NULL
|
Server ID
|
lid
|
VARCHAR(36) NOT NULL
|
interserver connection UUID
|
id
|
VARCHAR(36) NOT NULL
|
station ID
|
name
|
TEXT DEFAULT ''
|
station name
|
group_name
|
TEXT DEFAULT ''
|
station primary group name
|
category
|
INTEGER NOT NULL
|
environment category: Windows updates, hardware, software
|
arrived
|
NUMERIC(17) NOT NULL
|
record modification time
|
ref
|
VARCHAR(36) NOT NULL
|
reference to `srv_env_hw`, `srv_env_kb`, `srv_env_sw`
|
Table indexes
Index name
|
Index type
|
Fields list
|
srv_env_meta_pkey
|
table primary key
clustering index
|
id, category, osid
|
srv_env_sw
Detailed information on software on stations of the neighbor Server.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
reference UUID
|
name
|
INTEGER NOT NULL
|
software name, reference to `env_strings`
|
version
|
INTEGER NOT NULL
|
software version, reference to `env_strings`
|
vendor
|
INTEGER NOT NULL
|
software vendor, reference to `env_strings`
|
disksize
|
INTEGER NOT NULL
|
size in MB
|
Table indexes
Index name
|
Index type
|
Fields list
|
srv_env_sw_0001
|
simple table index
clustering index
|
id
|
Table references
Field name
|
Direction
|
Referenced table field
|
name
|
↔
|
env_strings.id
|
vendor
|
↔
|
env_strings.id
|
version
|
↔
|
env_strings.id
|
srv_status
Statistics on a state of neighbor Servers stations.
Table fields
Field name
|
Field type
|
Description
|
osid
|
VARCHAR(36) NOT NULL
|
originator ID
|
lid
|
VARCHAR(36) NOT NULL
|
interserver connection UUID
|
lname
|
INTEGER DEFAULT '0'
|
neighbor Server name
|
mid
|
VARCHAR(36) DEFAULT ''
|
message UUID
|
severity
|
NUMERIC(11) DEFAULT '0'
|
status severity
|
source
|
NUMERIC(11) DEFAULT '0'
|
status source
|
reserved
|
NUMERIC(11) DEFAULT '0'
|
reserved part of status
|
code
|
NUMERIC(15) DEFAULT '0'
|
record code
|
records
|
INTEGER DEFAULT '0'
|
station number
|
arrived
|
NUMERIC(17) NOT NULL
|
record creation
|
Table indexes
Index name
|
Index type
|
Fields list
|
srv_status_0001
|
simple table index
clustering index
|
arrived
|
srv_status_0002
|
simple table index
|
lid, osid
|
srv_status_0003
|
simple table index
|
osid
|
Table references
Field name
|
Direction
|
Referenced table field
|
lname
|
↔
|
cat_name_links.id
|
osid
|
←
|
srv_recvhistory.mid
|
|