NetIQ Sentinel 220.127.116.11 Sentinel Server
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 18.104.22.168 and later to show a more user friendly version. E.g. May 24, 2017 10:09:10 AM. However after applying the patch to 22.214.171.124 the alert-stored-date and alert-modified-date is still not being displayed correctly in the UI.
1. Go to the following location:
2. Type su novell3. Enter command:
4. Go to following location:
5. Enter command:
./psql SIEM dbauser
You should see the following prompt:
6. Type the following sql commands:
update esec_display set type = 2 WHERE tag= 'amoddt';and thenupdate esec_display set type = 2 WHERE tag= 'astrdt';
After each command you should see the following results:
7. Once completed exit psql by typing
\q and hit enter.
If the patch was applied to Sentinel version 126.96.36.199 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.