Kaspersky Security Center 14

Creating an SQL query using the klsql2 utility

26 February 2024

ID 151343

This section describes how to download and use the klsql2 utility, and how to create an SQL query by using this utility.

To use the klsql2 utility:

  1. Locate the klsql2 utility in the installation folder of Kaspersky Security Center. Do not use klsql2 utility versions intended for older Kaspersky Security Center versions.
  2. Create the src.sql file in any text editor and place the file in the same folder with the utility.
  3. In the src.sql file, type the SQL query that you want, and then save the file.
  4. On the device with Kaspersky Security Center Administration Server installed, in the command line, type the following command to run the SQL query from the src.sql file and save the results to the result.xml file:

    klsql2 -i src.sql -u <username> -p <password> -o result.xml

    where <username> and <password> are credentials of the user account that has access to the database.

  5. If required, enter the login and password of the user account that has access to the database.
  6. Open the newly created result.xml file to view the SQL query results.

You can edit the src.sql file and create any SQL query to the public views. Then, from the command line, execute your SQL query and save the results to a file.

See also

Scenario: configuring event export to SIEM systems

Did you find this article helpful?
What can we do better?
Thank you for your feedback! You're helping us improve.
Thank you for your feedback! You're helping us improve.