About Database

The single database is connected to the central protection Dr.Web Server and stores statistic data on anti-virus network events, settings of Dr.Web Server itself, parameters of protected stations and anti-virus components installed on protected stations.

You can use the following types of databases:

Embedded database. The SQLite3 database that is embedded directly into the central protection Server is provided.

External database. Inbuilt drivers for connecting the following databases are provided:

•MySQL,

•Oracle,

•PostgreSQL (including Postgres Pro),

•ODBC driver to connect other databases such as Microsoft SQL Server/Microsoft SQL Server Express.

You can use any database that corresponds to your demands. Your choice should be based on the needs that must be satisfied by the data store, such as: capability to service the anti-virus network of corresponding size, features of database software maintenance, administration capabilities provided by the database itself and also requirements and standards which are accepted for use in your company.

Database Version

Version of the database structure: 522.

To find the version of the database of your Dr.Web Server

1.Open the Control Center of your Dr.Web Server.

2.Go to the Administration → SQL console section.

3.Enter the following query:

4.Click Execute.

Database Subsystems

All tables of Dr.Web Server database can be divided into the following subsystems:

Database Metadata

Metadata that describe the database model (physical and partly logical model in the tables_refs table).

Notifications

Existing notifications descriptions and variables used.

Templates.

Settings for notification sending, assignation of notifications to administrators.

Web console notifications.

Pending notifications.

Administrators

Administrators and administrator groups, their permissions.

Messages sent by administrators to stations and their templates.

License Manager

License keys assigned at Dr.Web Server.

Propagation of licenses between stations, groups, policies, neighbor Dr.Web Servers.

License usage reports.

Catalogs

Catalogs of data frequently referenced by other tables.

Stations and Anti-virus Network Tree

Stations, groups, policies, Proxy servers, their attributes and hierarchy.

Neighborhood

Interserver connections with neighbor Dr.Web Servers.

Application Control

Generation of trusted applications of the Application Control component: settings, collected applications, intermediate data.

Application catalog data on process blocking and activity.

Dr.Web Server Configuration

Dr.Web Server configuration.

Stations Configuration

Settings of stations and Proxy servers: component configurations, schedule, permissions, update restrictions.

Groups Configuration

Settings of station groups and Proxy server groups: component configuration, schedule, permissions, update restrictions.

Policies Configuration

Settings of policies: components configuration, schedule, permissions, updates restrictions.

Other Objects Configuration

Profiles of the Application Control component, their rules and user settings of components.

Dr.Web Server Events

Events generated by Dr.Web Server:

•audit log, Task Scheduler, updates;

•messages sent by the administrator to stations;

•for Dr.Web AV-Desk: financial operations.

Stations Events

Events generated by stations:

•threat detection, errors and scan statistics;

•events of the Application Control component;

•device blocking;

•installation and deinstallation of the Agent;

•log of the Task scheduler on stations;

•geolocation of stations.

Stations Events from Neighbor Dr.Web Server

Events generated by stations on neighbor Dr.Web Servers (similar to Stations Events).

Server Status

Current state of the Dr.Web Server subsystems, including news, delayed updates of products.

Station statuses

Station states, including:

•abnormally terminated connections;

•installed components and their state (started/stopped), modules and virus databases;

•information on hardware and software, users of stations;

•registered connections of the Agent and Dr.Web Server;

•quarantine;

•opened user sessions.

Stations Status from Neighbor Dr.Web Server

State of the neighbor Dr.Web Server stations, including information about hardware and software.

Other Tables

Other reference and operational data.