[Spce-user] CDR Timestamps

[Rene Krenn]

Hi,

 

> Does anyone know how to adjust the time stamps on the call history when looking at subscribers?  

 

Good news - we started to introduce timezones throughout ngcp, and CDR/EDR exporters are already covered (5.5.x backports pending).

 

No need to change the system timezone, instead it can be configured per subscriber/contract/reseller (using inheritance logic).

 

There are are new „localized“ variants of the export columns showing datetime:

 

CDR:

 

TIMEZONE

INIT_TIME_LOCALIZED

START_TIME_LOCALIZED

END_TIME_LOCALIZED

 

EDR:

 

TIMESTAMP

EVENT_TIMESTAMP

EVENT_TIMEZONE

EVENT_TIMESTAMP_LOCALIZED

 

With „all of my time stamps seem to be 5 hours“ you most likely refer to the call start or init time, which are stored as epoch, and you them in UTC.



Applying timezones to Panel UI timestamps is implemented soon. Meanwhile, a „tz“ parameter is supported for the calllist rest-api.

 

regards

 

Von: Spce-user [mailto:spce-user-bounces at lists.sipwise.com] Im Auftrag von Brian Pelletier
Gesendet: Mittwoch, 21. März 2018 20:39
An: spce-user at lists.sipwise.com
Betreff: [Spce-user] CDR Timestamps

 

Does anyone know how to adjust the time stamps on the call history when looking at subscribers?  I am running 5.5.3 and in the eastern time zone.  My system time shows correct along with the correct time zone.  All of the different places i have been able to fine a setting for time zones seem too all match within SPCE itself when i query the mysql database for its time it returned everything correctly. all of my time stamps seem to be 5 hours ahead of what they should be.



Brian Pelletier

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20180321/781a006a/attachment-0001.html>