When viewing attachments, if there are no attachments, we show a message: "No data to display"

The reason for this could be:

1. Attachments are deleted using the Purge Data Process
2. User changes the URL 

Enhanced the Utility "UTILITY.GetSQLConnections" to improve readability in the event log.

The new message reads:
Event Log SQL Server Connection Information. Events: Filtered: 4, DBTasks: 4, Total: 58, Blocks: 0. Filters: HostName: All, Status: All, DBName: DEV-LinkSOFT, ProgramName: All Start: 30-07-24 09:41:34 AM Finish: 30-07-24 09:41:34 AM Duration: < 1s

Improved "Process Setup" so that the "SQL Agent" takes priority when it is available, and it is turned on. 

If the Agent is NOT turned on, the IIS Application Pool can take over the Agent responsibility.

Corrected issue where the "Process "ESS020: Pending Leave Approval Alert" takes a long time to cmplete because there exists a User with a blank username. To avoid this scenario, the alert is set to ignote users that do not comply with username validation.

The "Company Administration -> Processes" display was updated to show all processes with a valid license, as well as any active processes without a valid license. This change was made because we discovered active processes in unlicensed modules that users could not deactivate, as they were not previously visible.

Background Processes - Refactored code.

Streamlined code for  "If Process Changed"

When selecting the JOB to process, we get the longest waiting job first. ("Order by Next Run Date")

Changed Policy Automation to run "Purge Process" (SYS004) at 10PM so that it does not interfere with other processes running at 9PM daily. 

Interference with SYS004 is possible as it is run on a parallel thread (Named: LinkReplication") compared to Backups and other processes which run in a thread called "LinkADMIN"

Changed "System Log Alert" and "Health Check" alerts to contain a parameter called "NumberOfDays" (Default = 7).

This parameter limits the number of days to collect data, so we do not exceed the Emil Size limits.

We also changed the Alert List order by Date.

Improved menu: "Global Administration ~> Process Setup" Status column based on the following rules:

1. When Disabled, Enable = 0

2. When Process is edited and saved, the status is changed to "Service restart required"

3.We know the START and END times

4. If the Last Start date is not provided, we know there has been a reset. We therefore check the "Last Modified Date" with the Frequency in Seconds

5. When the Last Start date is more than 60 seconds past the next run, we display a Delay in the status.

6. If the delay is < 60 seconds, we assume this is normal

For SQL Agent:

  a. We can check the AGENT Status

  b. We must have at least one SYS001 running

Corrected issue with POS DEFAULT LOCATION  and Available Location conflict.

Issue: When Available Location  does not contain the Default Location, an error is raised. 

Solution: Instead of raising an error, we select the first item from the  "Available Location" list. 

Improved Process Status - Show "Waiting for next Run" countdown in menu: "Company Administration ~> Processes"