Databases – basic information and the code of good practice

  1. Statlook supports two types of database engines:.
  • Microsoft SQL Server both in free and commercial use (free Expess version offers 10GB of free space)
  • PostgreSQL – which is offered for free (Statlook supports PostgreSQL v. 9.3 and newer releases)

The system informs about the type of database engine and its size in Master’s Console dashboard.

the data about the database used by statlook system
The tile in Master Console describes in detail what kind of database is used
  1. A well-thought configuration of Statlook allows you to safe plenty of space on the disc. Firstly, we have to answer few important questions: What kind of data would we like to collect? How often should the data flow to the server? The main elements that increase the size of the database are Windows Event Log and the pieces of data that are gathered in short intervals.

Statlook divides the process of data gathering and is able to successfully limit its scope. Because of that, an Administrator may focus on most valuable information about the workstations.

the means by which uplook Agents will gather data
The options that allow statlook system to set appropriate data gathering parameters

Another important task from the administrator’s point of view is to set time intervals appropriately. Optimally, the intervals should be set on 10min/20min – the first value describes the time needed to download the tasks from the server, the second one – the time spent on sending the results to the server. Such settings will balance both efficiency and possibility to quickly access the data.

the general settings enable the user to gather the data in the scope of time and data that he needs
uplook Agents can be set according to the company’s individual practices

The system also provides a comfortable means of database management by offering an automated maintenance. By keeping it, you make sure that only valid data will be kept. It is recommended for each company to approach maintenance process individually.

By doing maintenance frequently you keep only the data you need
Maintenance option allows you to save plentiful of space
  1. It can be estimated that to provide a full serviceability of user and computer monitoring for 100 workstations with limited file scanning the database expands by 1 GB of data per one month. This estimation, however, is not unambiguous, as the expansion is dependent on several factors:
  • Which uplook Agent components were activated (Computers, Audit, Monitoring, Datalook, Helpdesk, etc.)?
  • How have you configured your Agent – meaning which pieces of data are gathered (e.g. process window header monitoring, external devices, mouse and keybord activity monitoring etc.)?
  • How often a scan is performed and what kind of scan is it (Hardware, Software, multimedia etc.)?
  • Another factors which do not depend on a system (e.g. the number of system errors in time of the process of data gathering by the system)
  1. Statlook also offers the tools to perform database backup and database migration (between MS SQL and PostgreSQL).

(path: C/ProgramFilesx86/AplusCSystems/uplook/Server)

The first tool ensures that the data will remain secure in case a danger of their loss or damage would appear. The other one enables you to move the database e.g. from MSSQL Express to PostgreSQL .

Data migration allows you to change database engine e.g. from MS SQL to PostgreSQL
uplook Data Migration allows you to change your database according to your needs
To keep your data safe if a danger of loss or damage appears, it is recommended to do a backup
uplook Data Backup helps you to keep your database secure


Was this article helpful?

Related Articles