Skip to main content

Accessing Logs and Using the Log Reader

The Known Keep VTR Log Reader is a simple console application designed to help you review recent log records from your Virtual Task Runner system.

The app reads log records stored in VTR.DB, a SQLite database located in the same App_Data directory as the Log Reader. This database is not password protected, allowing you to connect and read it with any SQLite-compatible utility if desired.

When you run the Log Reader, it will prompt you to:

  1. Choose to (D)isplay records on screen or (E)xport them to a file (export.txt in the app's directory).
  2. Specify how many records to review or export.
  3. Filter the records by (A)ll records, (1) for Reads (fetching tasks), or (2) for Runs (executing tasks).
(D)isplay to Screen or (E)xport to File? D
How Many Recent Log Entries Would You Like To See? 99
(A) for All Types, (1) for Reads, or (2) for Runs: A
----------------------------------------------------------------------------------------------------
User ID        IP Address     Date and Time            Type        Task Name
----------------------------------------------------------------------------------------------------
Bruce          99.233.999.111 10/20/2024 2:50:57 PM    Read        Fetched 10 task(s)
Bruce          99.233.999.111 10/20/2024 2:50:55 PM    Run         VTR-TEST-E
...

The VTR application logs an entry anytime someone connects to fetch tasks or run a task. Each log entry includes the User ID (created by the end user), IP Address of the connection, date and time, and the type of connection (Read or Run).

To maintain performance, the application is configured to clean up the database occasionally. Once it grows to 100,000 log entries, it will automatically trim it to 50,000 by removing the oldest records. For perspective, 50 connections per day would generate around 15,000 log records annually. It would take almost 7 years to generate 100,000 records, so 3 to 7 years of logs should be ample for auditing purposes.

Lastly, just as a reminder, NOTHING from these logs is accessed by or shared to Known Keep (the creators of Virtual Task Runner). This logging feature is strictly for your use. We don't track usage/stats, exceptions, or anything else. The ONLY thing we track is whether you are licensed to use the app or not. There is a single licensing call made every now and then to our server. That's it. There are no other connections to Known Keep.

Back to top