57 lines (42 loc) · 1.56 KB

Kaspersky Security Center database tables parser | KSC DBMS | ALTS

The script is intended for parsing of resulting files (all_tables_sizes)

Demo

Fast start

How to launch application

load the project, put all the files in a single directory;
install Python 3.13 or higher (if absent);
open the administration console (CMD), enter the commands:

pip install -r requirements.txt

cd [The path to the catalog where Source.zip files]

Console version:

Python main.py

User interface version:

Python gui.py

The data is presented as follows:

Click to open

DB Type
Updates
DB Name
Creator
Creation date
Current Volume
Maximal Volume
[Table] Tables in size (MB)
[Table] Events stored in the database
Events count

Pars the resulting files from the following DBMS:

Microsoft SQL (MSSQL)
PostgreSQL
MariaDB
MySQL

How to get result.xml files

The resulting files are unloading information from the Kaspersky Security Center database

To obtain files you need::

Download .sql-files all_tables_sizes for creating request to DBMS
Through the utility klsql2

An example of a request for a KSC database (MSSQL) via KLSQL2:

cd "C:\Program Files (x86)\Kaspersky Lab\Kaspersky Security Center"

.\klsql2 -i all_tables_sizes_mssqlsrv.sql -o result.xml