About Database

The single database is connected to the central protection Server and stores statistic data on anti-virus network events, settings of the 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 into the central protection Server directly 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: 473.

To find the version of the database of your Server

1.Open the Control Center of your 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 on 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.

Notifications send configuration, assigning them to administrators.

Web console notifications.

Notifications of all types that are waiting to be sent.

Administrators

Administrators and groups pf administrators, their permissions.

Messages sent by administrators to stations and their templates.

License Manager

License keys assigned at the Server.

Propagations of licences between stations, groups, policies, neighbor Servers.

Licenses usage reports.

Catalogues

Catalogs with frequently repeated data on which other tables are refer.

Stations and Anti-virus Network Tree

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

Neighborhood

Interserver connections with neighbor Servers.

Application Control

Infrastructure of trusted applications generating for the Application Control component: settings, collected applications, intermediate data.

Data of applications catalog received by collecting processes blockings and activity.

Server Configuration

Dr.Web Server Configuration

Stations Configuration

Settings of stations and Proxy servers: components configuration, schedule, permissions, updates restrictions.

Groups Configuration

Settings of station groups and Proxy server groups: components configuration, schedule, permissions, updates 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.

Server Events

Events generated by the 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:

•threats detection, errors and scan statistics;

•events of the Application Control component;

•devices blockings;

•the Agent installation and deinstallation;

•log of the Task scheduler on stations;

•stations geolocation.

Stations Events from Neighbor Server

Events generated by stations on neighbor Servers (similarly).

Server Status

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

Station statuses

Stations state, 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 the Server;

•quarantine;

•opened user sessions.

Stations Status from Neighbor Server

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

Other Tables

Other reference and operational data.