Company: Link Technologies
Case No: L12918. Project: 15.00: LinkSOFT Version 15.00
Logged By: Sanjay (Link Technologies) on 26 Jun 2023 05:33PM
Priority: Low
Product: Framework
Group: Enhancement
Time Taken: 39.00 (Weight: 80.00)
Assigned To: Sanjay (Link Technologies)
Circulation: Sanjay
Resolve By: Tuesday, 31 October 2023 12:00 PM [301 days since logged date]
Status: Closed
Subject: Policy Automation for LinkSOFT

Add Policy Automation so users can enforce standard configuration settings using SQL Agent Automation.

Example: The following script can be scheduled to run daily ensuring that the "Admin Account" will not require Email 2FA. This can be useful in TEST environments as an example.

EXEC LT_SYS_UTILITY_PolicyAutomation

@Username = 'LINKADMIN',

@Password = 'Infotech0410',

@AdminAccountRequiresEmail2FA = 'N'

Audit Notes:
27 Jun 202312:05PM Comment 1 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 31-10-2023 12:00 PM Time Taken: 30.00 Notes: ETC extended from: 26/06/2023 to 31/10/2023
PART A - Development work for this case has been completed.

1. The change will be available in version: 15.00

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

Added the following options to a new procedure named: LT_SYS_UTILITY_PolicyAutomation. Default values are set as follows:

  1. @BackupPath 'H:\MSSQL\Backup'
  2. @BackupRetentionDays '1'
  3. @EnableBackup 'Y'
  4. @BackupThisDatabase 'Y'
  5. @BackupOtherDatabasesCSV ''
  6. @BackupFTPUpload 'Y'
  7. @EnableIndexTuning 'Y'
  8. @EnablePurgeProcess 'Y'
  9. @MaxDaysToKeep_Audit '365'
  10. @MaxDaysToKeep_Purge '365'
  11. @PurgeRecruitmentData 'Y'
  12. @LogEmailAddress ''
  13. @AdminAccountEmailAddress ''
  14. @AdminAccountRequiresEmail2FA 'Y'
  15. @ForceEmail2FA 'Y'
  16. @DisableUsersWithNo2FA 'Y'
  17. @MaxEmailSizeKB '102'
  18. @MaxEmailAttachmentSizeKB '2048'
  19. @ProcessStartAt '1900-01-01 04:00:00.000'
  20. @ProcessEndAt '1900-01-01 22:00:00.000'
  21. @ActivateTestMode 'N'

3. Affected Areas:

  1. Automation Tasks

4. The issue was caused by:

  1. Improvement

5. Other Relevant Notes: To implement this automation, create a Scheduled Task in SSMS and apply the necessary parameter values.
6. Next Step
(Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT

30 Aug 202303:19PM Comment 2 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 08-09-2023 03:17 PM Time Taken: 9.00
The following tests were performed:

Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1Apply parameters one by one and apply them to the UAT Environment
Verify the configuration changes are applied

Environment Details

  1. OS version: Win11
  2. Application version: 14.
  3. Setup on:
    1. Server: LinkQA4
    2. Database: LinkSOFT
    3. LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
  4. Login Details: Standard username and password for user "admin"

Next Step: Closure

If you have any queries regarding this support incident, please email and include the Case No: L12918 in the subject line of all emails regarding this issue.

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