Date\time type fields not formatted correctly

In previous versions of Sentinel the date\time format was not displayed in a user friendly format. E.g. 2017-05-24T10:09:10.743Z. This was addressed in versions 8.0.1.1 and later to show a more user friendly version. E.g. May 24, 2017 10:09:10 AM. However after applying the patch to 8.0.1.0 the alert-stored-date and alert-modified-date is still not being displayed correctly in the UI.

1. Go to the following location: 

cd /opt/novell/sentinel/bin

2. Type su novell

 

3. Enter command: 

source setenv.sh

4. Go to following location: 

cd /opt/novell/sentinel/3rdparty/postgresql/bin

5. Enter command: 

./psql SIEM dbauser

You should see the following prompt: 

SIEM=#

6. Type the following sql commands: 

update esec_display set type = 2 WHERE tag= 'amoddt';

and then

update esec_display set type = 2 WHERE tag= 'astrdt';

After each command you should see the following results: 

UPDATE 1

7. Once completed exit psql by typing 

\q    and hit enter.

If the patch was applied to Sentinel version 8.0.1.0 all of the date field formats are fixed to show the new date\time formatting except for the alert-stored-date and the alert-modified-date.