[Spce-user] CDR Timestamps
brian.pelletier at aloe-me.net
Wed Mar 21 21:48:35 EDT 2018
So just to verify that I am understanding all of that right as of right now call records for the subsriber will always siwn with a UTC time stamp? And when I export for use of an external billing system the timestamp should show correct for whatever I have set?
---- On Wed, 21 Mar 2018 16:56:00 -0400 rkrenn at sipwise.com wrote ----
> 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:
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.
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.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Spce-user