Files Page

You can access the full list of queries run through DbRunner on the Files page. This page contains statistics, such as which user ran which query. If you want to search for a table within a file, you can do so from this page. For example, typing %DELETE%HR.TEST% in the search box will list the files containing the delete operations performed on the HR.TEST table. % and _ are special characters. They represent the conditions used in the LIKE statement when querying the database.

To search within files, the relevant statistics settings must be enabled. Otherwise, this feature will not work.

Collecting file statistics

Analyzing user-uploaded files is possible. When this feature is enabled, you can search for a term within the file in the search box under the "Files" page. To activate the feature, follow the steps below.

For example, typing %DELETE%HR.TEST% into the search box will list the files containing the delete operations performed on the HR.TEST table. The % and _ characters are special characters. They represent the conditions used in the LIKE statement when querying the database.

After connecting to the database in DbRunner, run the following command and then restart the application.

UPDATE srv_parameters
SET p_val = '1'
WHERE p_key = 'DBRUNNER_FILE_STATS';