Company: Link Technologies
Case No: L12237 Project: 13.10: LinkSOFT version 13.10 - Improvements and stabilisation.
Logged By: Rashna (Edge Business Solutions) on behalf of Sanjay (Link Technologies) on 23 Apr 2021 07:37PM
Priority: Medium
Product: Framework
Group: Enhancement
Time Taken: 9.00 (Weight: 12.00)
Version: 13.10.1011
Assigned To: Sanjay (Link Technologies)
Circulation: Development, Rashna, Sanjay
Resolve By: 30 Sep 2021 [180 days since logged date]
Status: Closed
Subject: LinkSOFT "Audit Data" is not informative for analysis and reporting
Summary:    

Verified in version 12.40.0420RC!1

  1. This case has been created after support case E01201.
  2. We capture modifications to a record in LinkSOFT under "Audit Data".
  3. However, all modifications are recorded under "Username = Linkadmin" 
  4. With the above, we do not know who is the actual user who had modified the record.For example.
    1. User A logged in and changed the TIN number for employee E001.This caused a duplicate in the system.
    2. Now the department wants to investigate who had made this change.
    3. We can not get this information from the audit as the user is "Linkadmin".
Audit Notes:Edited by sanjay on 22/09/21 11:48. Edited by sanjay on 21/09/21 09:38. Edited by sanjay on 21/09/21 09:37. Edited by sanjay on 21/09/21 09:35. Edited by sanjay on 26/04/21 13:54. Edited by rashna on 23/04/21 19:37. 
26 Apr 202101:54PM Comment 1 by Sanjay (Link Technologies) Case L12237 added to project 999
26 Apr 202101:58PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development (Link Technologies) Follow up Date: 31/12/2021

Hi Rashna, yes this is a known issue as all users are routed vis the Application Pool user, in this case, it is "LINKADMIN". An alternative will be to use the User Identity to start the Application pool. We are looking at the best way to address this issue.

We hope to have this addressed in version 12.5


    26 Aug 202101:24PM Comment 3 by Rashna (Edge Business Solutions) Assigned To: Development (Link Technologies) Follow up Date: 31/10/2021 Time Taken: 1.00 Notes: ETC extended from: 24/04/2021 to 31/10/2021

    As per the development meeting with Sanjay, Alvis, Sitla, Vineshwar, and Rashna

    1. This case requires framework changes.
    2. As per comment 2, the case was not developed in 12.5 due to major license changes.
    3. We have agreed to add this case to the "October" build. Thus case assigned to development.

    Thanks
    Rashna


    21 Sep 202109:35AM Comment 4 by Sanjay (Link Technologies) Case L12237 added to project 13.04
    21 Sep 202109:35AM Comment 5 by Sanjay (Link Technologies) ETC was changed from 31/10/2021 to 30/09/2021
    21 Sep 202109:37AM Comment 6 by Sanjay (Link Technologies) ETC was changed from 30/09/2021 to 30/09/2021
    21 Sep 202101:49PM Comment 7 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Follow up Date: 22/09/2021 Time Taken: 6.00
    PART A - Development work for this case has been completed.

    1. The change will be available in version: 13.04

    2. The following changes were made(Include Database object names, Program classes, and any other relevant information):

    1. "Logged by" cannot be changed at this stage, so we have opted to display user records clearly in the data fields. This will allow users to see who has modified the records.
    2. Changed "User Modified", "Approved By", "Requested By" and "User Created" fields to store actual user name in the audit data

    3. Affected Areas:

    1. Audit

    4. The issue was caused by:

    1. Improvement

    5. Other Relevant Notes
    6. Next Step
    (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT


    24 Sep 202102:15PM Comment 8 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Follow up Date: 28/09/2021 Time Taken: 1.00
    The following tests were performed:

    Table 1 - Test Results
    #Test Case DetailsPass/FailComments
     1
    1. Enable audit on the "Direct Credit" table.
    2. Edit the bank details for employee E013.
    3. Verify that the user modified is updated in the audit data
     Pass 

    Environment Details

    1. OS version:
    2. Application version: 13.03.9023RC
    3. Setup on:
      1. Server:LinkQA4
      2. Database: UAT-LINKSOFT
      3. LinkSOFT URL: HTTP://10.0.0.13/LINKSOFT
    4. Login Details: Standard username and password for user "admin"

    Next Step:Closure


    24 Sep 202103:05PM Comment 9 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Follow up Date: 28/09/2021 Time Taken: 1.00
    Thanks Rashna

    If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12237 in the subject line of all emails regarding this issue.

    Document size: 8.3 KB
    For call complaints, please contact the Managing Director of the company using this form