|
srv_env_hash
Hash list of information states about hardware and software on neighbor stations.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
reference UUID
|
hash
|
VARCHAR(128) NOT NULL
|
environment category hash
|
createtime
|
NUMERIC(17) NOT NULL
|
record creation time
|
Table indexes
Index name
|
Index type
|
Fields
|
srv_env_hash_pkey
|
table primary key
|
id
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
srv_env_meta.ref
|
srv_env_hw
Detailed information on hardware on stations of the neighbor Dr.Web Server.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
reference UUID
|
type
|
INTEGER NOT NULL
|
device type, see module st-db-env-hw
|
name
|
INTEGER NOT NULL
|
device name, reference to table env_strings
|
vendor
|
INTEGER NOT NULL
|
device vendor, reference to table env_strings
|
info1
|
NUMERIC(11) NOT NULL
|
device information, line #1
|
info2
|
NUMERIC(11) NOT NULL
|
device information, line #2
|
instance
|
INTEGER DEFAULT '0' NOT NULL
|
device sequence number
|
Table indexes
Index name
|
Index type
|
Fields
|
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 Dr.Web Server.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
reference UUID
|
name
|
INTEGER NOT NULL
|
Windows update name, reference to table env_strings
|
Table indexes
Index name
|
Index type
|
Fields
|
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 Dr.Web Server.
Table fields
Field name
|
Field type
|
Description
|
osid
|
VARCHAR(36) NOT NULL
|
server ID
|
lid
|
VARCHAR(36) NOT NULL
|
interserver connection ID
|
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
|
UUID to support stations with the same ID on different Dr.Web Servers
|
Table indexes
Index name
|
Index type
|
Fields
|
srv_env_meta_0001
|
simple table index
|
ref
|
srv_env_meta_pkey
|
table primary key
clustering index
|
id, category, osid
|
srv_env_sw
Detailed information on software on stations of the neighbor Dr.Web Server.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
reference UUID
|
name
|
INTEGER NOT NULL
|
software name, reference to table env_strings
|
version
|
INTEGER NOT NULL
|
software version, reference to table env_strings
|
vendor
|
INTEGER NOT NULL
|
software vendor, reference to table env_strings
|
disksize
|
INTEGER NOT NULL
|
size in MB
|
Table indexes
Index name
|
Index type
|
Fields
|
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 Dr.Web Server stations.
Table fields
Field name
|
Field type
|
Description
|
osid
|
VARCHAR(36) NOT NULL
|
originator ID
|
lid
|
VARCHAR(36) NOT NULL
|
interserver connection ID
|
lname
|
INTEGER DEFAULT '0'
|
neighbor Dr.Web 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
|
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
|
|