LinkSOFT logs messages into the event log to keep the user informed. This case is about improving the logging messages and adding more messaging so the user is aware of all tasks.

Design:

We need to ensure that the Event Log is not overwhelmed with messages, at the same time, we need a good balance between useful information users and consultants can use for diagnostics and performance tuning. The following design is proposed:

1. Add a global setting at the Company level that flags if the event log should capture the Performance log
2. In all procedures, we track the start and end time, then add a log entry if the time taken exceeds a pre-configured amount. This is especially important for processing functions
3. Where possible, log 2. above with some data that users may find useful
4. The log entry should be of the format:
   1. Message: Performance log. {Source}. {Processing Time(ms)}. {Summary Relevant Information}
   2. log data: JSON or plain text containing relevant information

Development Log:

1. Refactored procedure "LT_SYS_Log_Insert" to make "Consolidate" configurable
2. Added new procedure "LT_SYS_Log_Event" to handle Event and performance  entries

Nest Step:

1. Determine where to store logging configuration
2. Apply event logging in critical functions
3. Add event logging to framework 

The following changes were implemented

1. "Global Administration ~>  Event Log" View option?
2. "Global Administration ~>  Database Backup" - Added Detailed logging and Log views
3. "Global Administration ~> Company" - Added DELETE and UPDATE logging. Added Log view.
4. "Global Administration ~> Audit Setup" - Added DELETE and UPDATE logging. Added Log view.

The following changes were implemented

1. "Global Administration ~>  Event Log" View option?
2. Adde user account change logging at all of the following points:
   1. User created
   2. User logged in
   3. User password reset
   4. Add/Remove roles from a user
   5. Unlock a user

Added Event Logging for the following:

1. User maintenance
   1. Create User
   2. Recover Password
   3. User Login
   4. TFA email
   5. Add/Remove User Role
   6. Add/Remove User access to company
   7. Change in Workflow
   8. Reset password

Added logging to the following:

1. Additional Fields/Rule - Added column IsUsed and Allow user to remove field and contents
2. Added logging to Additional Field/Rule DELETE
3. Added logging for "Company Administration ~> Processes". Changes in Process, Process Rules and Process Execution
4. Added Analysis computation so that Processes can average the last 10 executions instead of just the longest run time
5. Added Event logging for Organisation User List
6. Added Event logging for Configuration
7. Added Event logging for Integration Setup
8. Added Event logging for Email Log and Email Report log
   

Added logging in Database Utility to show the following:

1. Creating a new database
2. Start Upgrading
3. Finish Upgrading
4. User stops upgrade script process

Environment Details

1. Application version: 12.51
2. Setup on:
   1. Server: LinkQA4
   2. Database: DEV-LinkSOFT
   3. LinkSOFT URL: HTTP://10.0.0.14/DEV-LinkSOFT
3. Login Details: Standard username and password for user "admin"