Server Events

activity_data

Attributes of administrators actions audit.

Table fields

Field name

Field type

Description

record

VARCHAR(36) NOT NULL

record UUID

item

TEXT DEFAULT ''

parameter number

value

CLOB DEFAULT ''

parameter value

createtime

NUMERIC(17) NOT NULL

record creation time

Table indexes

Index name

Index type

Fields list

activity_data_0001

simple table index

clustering index

record

activity_data_0002

simple table index

createtime

Table references

Field name

Direction

Referenced table field

record

admin_activity.record

admin_activity

Audit of administrators actions.

Table fields

Field name

Field type

Description

record

VARCHAR(36) NOT NULL

record UUID

login

VARCHAR(36) DEFAULT ''

administrator login name

address

TEXT DEFAULT ''

administrator network address

subsys

INTEGER DEFAULT '0'

operation initiator: adm-subsys .ds/.h

objid

VARCHAR(36) DEFAULT ''

administrated object (group/station) ID

oper

INTEGER DEFAULT '0'

operation

status

INTEGER DEFAULT '0'

operation status: adm-status .ds/.h

createtime

NUMERIC(17) NOT NULL

record creation time

Table indexes

Index name

Index type

Fields list

admin_activity_0001

simple table index

clustering index

createtime

admin_activity_pkey

table primary key

record

admin_msg_log

Log of messages sent by administrator to stations.

Table fields

Field name

Field type

Description

sid

VARCHAR(36) NOT NULL

ID of the station to which the message was sent

mid

VARCHAR(36) NOT NULL

message UUID

admin

VARCHAR(36) NOT NULL

UUID of the administrator who sent the message

subsys

INTEGER DEFAULT '0'

operation initiator: adm-subsys .ds/.h

delivered

NUMERIC(17) DEFAULT '0'

message delivery time

Table indexes

Index name

Index type

Fields list

admin_msg_log_0001

simple table index

mid

admin_msg_log_0002

simple table index

sid

admin_msg_log_0003

simple table index

admin

admin_msg_log_pkey

table primary key

sid, mid

Table references

Field name

Direction

Referenced table field

admin

admins.id

mid

admin_msg_lst.mid

group_history

Log of operations with tariff groups (Dr.Web AV-Desk only).

Table fields

Field name

Field type

Description

id

VARCHAR(36) NOT NULL

group ID

oper

INTEGER DEFAULT '0'

operations, see st-history-values.ds

parent

VARCHAR(36) DEFAULT ''

parent ID

date1

NUMERIC(17) DEFAULT '0'

component number when changing installing components

date2

NUMERIC(17) DEFAULT '0'

value for group_install.imode

created

NUMERIC(17) DEFAULT '0'

record creation time

Table indexes

Index name

Index type

Fields list

group_history_0001

simple table index

clustering index

id

online_statistics

Statistics on detected threats sent to Doctor Web company.

Table fields

Field name

Field type

Description

station

VARCHAR(36) DEFAULT ''

originator station ID

sid

VARCHAR(36) DEFAULT ''

not empty if being processed now

recordtime

NUMERIC(12) NOT NULL

unix timestamp, rounded to an hour

virus

VARCHAR(4000) DEFAULT ''

empty if it is the `scanned` record

amount

NUMERIC(19) DEFAULT '1'

amount

Table indexes

Index name

Index type

Fields list

online_statistics_0001

simple table index

clustering index

sid, recordtime

server_jobs_log

Log of tasks execution on the Server.

Table fields

Field name

Field type

Description

id

VARCHAR(36) NOT NULL

record originator (Server ID)

name

INTEGER DEFAULT '0'

task name, ref cat_job

done

INTEGER DEFAULT '0'

0 if the task failed, != 0 if OK

completed

NUMERIC(17) NOT NULL

task completion time

error

INTEGER DEFAULT '0'

error message

Table indexes

Index name

Index type

Fields list

server_jobs_log_0001

simple table index

clustering index

completed, id

Table references

Field name

Direction

Referenced table field

error

cat_job_srv.id

name

cat_job.id

station_history

Operations log for financial report on stations (Dr.Web AV-Desk only).

Table fields

Field name

Field type

Description

id

VARCHAR(36) NOT NULL

station ID

oper

INTEGER DEFAULT '0'

operations, see st-history-values .ds/.h

rate

VARCHAR(36) DEFAULT ''

tariff ID

date1

NUMERIC(17) DEFAULT '0'

1st date for the period start (station creation, station expiration) or grace period duration

date2

NUMERIC(17) DEFAULT '0'

2nd date for the period end

created

NUMERIC(17) NOT NULL

record creation time

Table indexes

Index name

Index type

Fields list

station_history_0001

simple table index

clustering index

created, id

station_history_0002

simple table index

id

station_history_0003

simple table index

id, oper

update_srv_files

Log of the Server repository files updates.

Table fields

Field name

Field type

Description

id

VARCHAR(36) NOT NULL

update UUID, see update_srv_history

filename

INTEGER DEFAULT '0'

file name

filehash

TEXT DEFAULT ''

file hash

filesize

NUMERIC(19) DEFAULT '0'

file size

fileaction

INTEGER DEFAULT '0'

action: 0—add, 1—replace, 2—delete

starttime

NUMERIC(17) DEFAULT '0'

update start time, see update_srv_history

Table indexes

Index name

Index type

Fields list

update_srv_files_0001

simple table index

id

update_srv_files_0002

simple table index

clustering index

starttime

Table references

Field name

Direction

Referenced table field

filename

cat_upd_files.id

id

update_srv_history.id

update_srv_history

Log of the Server repository updates.

Table fields

Field name

Field type

Description

id

VARCHAR(36) NOT NULL

update UUID

sid

VARCHAR(36) NOT NULL

server ID

login

INTEGER DEFAULT '0'

administrator login name

address

TEXT DEFAULT ''

administrator network address

src

INTEGER DEFAULT '0'

initiator, see update-source .ds/.h

product

INTEGER DEFAULT '0'

product ID

descr

INTEGER DEFAULT '0'

product description

starttime

NUMERIC(17) DEFAULT '0'

start date

endtime

NUMERIC(17) DEFAULT '0'

end date

rc

INTEGER DEFAULT '0'

completion code

crevision

NUMERIC(17) DEFAULT '0'

current revision (DB time)

nrevision

NUMERIC(17) DEFAULT '0'

new revision (DB time)

Table indexes

Index name

Index type

Fields list

update_srv_history_0001

simple table index

clustering index

starttime

update_srv_history_pkey

table primary key

id

Table references

Field name

Direction

Referenced table field

descr

cat_upd_descr.id

login

cat_upd_admin.id

product

cat_upd_product.id

user_activity

Actions audit of Subscriptions Control Center users (Dr.Web AV-Desk only).

Table fields

Field name

Field type

Description

record

VARCHAR(36) NOT NULL

record UUID

login

VARCHAR(36) DEFAULT ''

user login name

address

TEXT DEFAULT ''

user network address

subsys

INTEGER DEFAULT '0'

operation initiator, see adm-subsys .ds/.h

objid

VARCHAR(36) DEFAULT ''

user object (group/station) ID

oper

INTEGER DEFAULT '0'

operation

status

INTEGER DEFAULT '0'

operation status, see adm-status .ds/.h

createtime

NUMERIC(17) NOT NULL

record creation time

Table indexes

Index name

Index type

Fields list

user_activity_0001

simple table index

clustering index

createtime

user_activity_pkey

table primary key

record

user_activity_data

Attributes of actions audit of Subscriptions Control Center users (Dr.Web AV-Desk only).

Table fields

Field name

Field type

Description

record

VARCHAR(36) NOT NULL

record UUID

item

TEXT DEFAULT ''

parameter number

value

CLOB DEFAULT ''

parameter value

createtime

NUMERIC(17) NOT NULL

record creation time

Table indexes

Index name

Index type

Fields list

user_activity_data_0001

simple table index

clustering index

record

user_activity_data_0002

simple table index

createtime

Table references

Field name

Direction

Referenced table field

record

user_activity.record