Audit Trail Management
Audit Trail Management
Embedded Files
Reports are essential tools for immediate analysis of a process.
Reports are essential tools for immediate analysis of a process.
Simple and immediate GUI
Simple and immediate GUI
The Graphic User Interface is designed in such a way as to allow the user to quickly apply filters and generate the audit trail report in just a few clicks.
Choice of audit trail file
Choice of audit trail file
The application allows you to select the audit trail file from which to extrapolate the information to generate the report.
Checksum control
Checksum control
Thanks to the use of the Siemens checksum on the CSV files, if a file is altered in any way, the application detects the modification and warns the user, not allowing him to generate the audit trail report.
Available filters
Available filters
The application prepares some filters on the database of the report, in such a way as to allow the user to select a part of the necessary data, warning him in the event that there are no data with the inserted filters.
Audit Trail Report
Audit Trail Report
After selecting the audit trail file and setting the desired filters, the user can generate the report, which is previewed after saving it.
Saving the report
Saving the report
The application allows you to choose the path and name of the report file.
User requirements
User requirements
The customer requires:
audit trail file selection;
file checksum checking;
filters on audit trail data;
report preview;
saving the report in PDF format.
Used softwares
Used softwares
AutoIt as a scripting language for the whole application (GUI, file selection, checksum control, transformation of the file from .csv to .db);
SQLite3 as database for better management than the .csv format;
Crystal Reports and VB.NET for managing reports and the report preview form.
Application description
Application description
The application was entirely developed using the AutoIt scripting language. It manages the GUI, thanks to which it is possible to select the audit trail file for which the report is to be generated;
only after checking the checksum of the .csv file, the user has the possibility to filter the data and start the generation of the audit trail report, which can be saved in a path chosen by the user.
For the preview form of the report, the VB.NET programming language was used, together with which the use of Crystal Reports is associated for the generation of the audit trail report.
Page updated
Google Sites
Report abuse