NetflowV9 from Untangle - timestamps starting from 1969?

[gsmith]

Hello,
I have been using Netflow for quit a while,

Double check your server ( NTP) and Untangle 16.4.1 Date/time.

I found these links.

https://forums.untangle.com/command-center/44591-last-seen-command-center-reverts-jan-1-1970-when-device-offline.html

https://wiki.untangle.com/index.php/Time_and_date_formatting

Also since you seam to be dealing with 1/1/1970 the "epoch time"

I have found this post

Epoch time fields in pipeline rule

I’m parsing some Cisco UCM call detail records into Graylog using a pipeline rule: rule "parse ucm cdr log" when has_field("ucm_type") && to_string($message.ucm_type) == "cdr" then let message_field = to_string($message.message); let parsed_fields = grok("..<omitted for brevity>..", message_field); set_fields(parsed_fields); let epoch = parse_date("1970-01-01T00:00:00.000Z", "yyyy-MM-dd'T'HH:mm:ss.SSSZ", "UTC"); let ts_seconds = seconds(to_long($message.ucm_dateTimeOrigination)); …

EDIT: With Untangle 16.4.1 I think you can change the date, time, and year from a prompt with this command.

date 060222212009 translate to January 21, 10:21pm year 2020

Other than that, the date command on the console is the only way.

Hope that helps