Skip to main content
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
Showing results for 
Search instead for 
Did you mean: 

Governance dasboard 2.1.4 datetime issue


The governance dashboard is not showing historical differences (previous session per user, sessions last 30 days) It looks like all the datefields are empty. I think because the timestamp cannot be formated correctly. Hope somebody could help me with it. 

This is the timestamp in our log files --> 20221218T100105.000+0100

In the governance script I see the following script/variables:

SET TimestampFormat = 'YYYY-MM-DD hh:mm:ss'; // This should be changed only if the Publisher machine in your system uses a timestamp format not included in the three TimestampFormat variables.

SET TimestampFormat1 = 'MM/DD/YYYY hh:mm:ss TT'; // First "fall back" timestamp option in case Publisher server has different locale/timestamp than the default.

SET TimestampFormat2 = 'DD.MM.YYYY hh:mm:ss'; // Second fall back timestamp format

Do I need to modify these, if yes how??

Thanks in  advance!!

Labels (2)
0 Replies