Having troubles extracting a time stamp.

cliffton_merz — Tue, 29 Sep 2020 15:47:48 GMT

Hello all,

I'm having an issue with my environment while trying to index a set of logs i get from a file nightly and attempt to process them. what is happening is splunk is not finding the timestamp and either setting it as file mod time or at index time. I do not have this issue with the other logs sent from this same server.(syslog server sending many logs). At the bottom are 3 log lines as an example.

I'm trying to extract the epoch timestamp from the start of the line. AV - Alert - "1504324797" --> i'm not seeing any failed to parse timestamp errors so i'm confused as to why this is being bypassed and setting it to the file mod time or index time.

The input stanza:
[monitor:///apps/alienvault/ossec-alerts-*.log]
whitelist=ossec-alerts
index = test
sourcetype = alienv
disabled = 0

Props.conf: (I've commented out the field extractions to make sure they arnt the issue.)
[alienv]
TIME_PREFIX = ^\w+\W+\w+\W+ I've also tried: AV - Alert - " , -\s\" , no time prefix and others
TIME_FORMAT = %s 10 digit epoch format
TZ = UTC

REPORT-alienv = av-syslog-hdr, av-syslog-user, av-syslog-srcip, av-syslog-location1, av-syslog-location2, av-syslog-message

REPORT-alienv-loc = av-syslog-location1, av-syslog-location2

FIELDALIAS-signature = action as signature

FIELDALIAS-src = src_ip as src

TRANSFORMS-sev = av-syslog-sev

TRANSFORMS-suppressions = av-win-suppress-detail

I have a distributed environment so i've placed the props.conf/transforms.conf on the indexers and search heads for search time field extractions. The indexers and search heads are version 6.5, the server i'm forwarding from uses a universal forwarder version 6.4.1

Log line examples:
AV - Alert - "1504324797" --> RID: "700008"; RL: "2"; RG: "windows,authentication_success,"; RC: "A Kerberos service ticket was requested: Success."; USER: "user@server.com"; SRCIP: "None"; HOSTNAME: "(Host-xxx-xxx-xxx-xxx) xxx-xxx-xxx-xxx->WinEvtLog"; LOCATION: "(Host-xxx-xxx-xxx-xxx) xxx-xxx-xxx-xxx->WinEvtLog"; EVENT: "[INIT]2017 Sep 02 00:00:02 WinEvtLog: Security: AUDIT_SUCCESS(4769): Microsoft-Windows-Security-Auditing: user@server.com: server.domain: server.domain: A Kerberos service ticket was requested. Account Information: Account Name: user@server.com Account Domain: server.domain Logon GUID: {5DDE4BE2-4A37-D51B-77F1-CDFE96B24E23} Service Information: Service Name: krbtgt Service ID: S-1-5-21-2277870611-162051517-1830794436-502 Network Information: Client Address: xxx.xxx.xxx.xxx Client Port: 65168 Additional Information: Ticket Options: 0x40810000 Ticket Encryption Type: 0x12 Failure Code: 0x0 Transited Services: - This event is generated every time access is requested to a resource such as a computer or a Windows service. The service name indicates the resource to which access was requested. [END]";
AV - Alert - "1504324797" --> RID: "700008"; RL: "2"; RG: "windows,authentication_success,"; RC: "A Kerberos service ticket was requested: Success."; USER: "user@server.com"; SRCIP: "None"; HOSTNAME: "(Host-xxx-xxx-xxx-xxx) xxx-xxx-xxx-xxx->WinEvtLog"; LOCATION: "(Host-xxx-xxx-xxx-xxx) xxx-xxx-xxx-xxx->WinEvtLog"; EVENT: "[INIT]2017 Sep 02 00:00:02 WinEvtLog: Security: AUDIT_SUCCESS(4769): Microsoft-Windows-Security-Auditing: user@server.com: server.domain: server.domain: A Kerberos service ticket was requested. Account Information: Account Name: user@server.com Account Domain: server.domain Logon GUID: {5DDE4BE2-4A37-D51B-77F1-CDFxxxxxxxxx} Service Information: Service Name: service$ Service ID: S-1-5-21-2277870611-162051517-1830794436-1296 Network Information: Client Address: xxx.xxx.xxx.xxx Client Port: 65170 Additional Information: Ticket Options: 0x40810000 Ticket Encryption Type: 0x12 Failure Code: 0x0 Transited Services: - This event is generated every time access is requested to a resource such as a computer or a Windows service. The service name indicates the resource to which access was requested. [END]";
AV - Alert - "1504324797" --> RID: "700008"; RL: "2"; RG: "windows,authentication_success,"; RC: "A Kerberos service ticket was requested: Success."; USER: "user@server.com"; SRCIP: "None"; HOSTNAME: "(Host-xxx-xxx-xxx-xxx) xxx-xxx-xxx-xxx->WinEvtLog"; LOCATION: "(Host-xxx-xxx-xxx-xxx) xxx-xxx-xxx-xxx->WinEvtLog"; EVENT: "[INIT]2017 Sep 02 00:00:02 WinEvtLog: Security: AUDIT_SUCCESS(4769): Microsoft-Windows-Security-Auditing: user@server.com: server.domain: server.domain: A Kerberos service ticket was requested. Account Information: Account Name: user@server.com Account Domain: server.domain Logon GUID: {5DDE4BE2-4A37-D51B-77F1-CDFxxxxxxxxx} Service Information: Service Name: service$ Service ID: S-1-5-21-2277870611-162051517-183079xxxx-xxxx Network Information: Client Address: xxx.xxx.xxx.xxx Client Port: 65169 Additional Information: Ticket Options: 0x40810000 Ticket Encryption Type: 0x12 Failure Code: 0x0 Transited Services: - This event is generated every time access is requested to a resource such as a computer or a Windows service. The service name indicates the resource to which access was requested. [END]";

Re: Having troubles extracting a time stamp.

sshelly_splunk — Tue, 29 Sep 2020 15:47:54 GMT

I used your sample data and came up with the following:
REG for time_prefix = ^.+?-.+?-\s+"
When I uploaded the file, splunk automatically sensed the epoch timestamp, but I always specify time format and time prefix, so I cam up with the following:

[timestamp_test]
DATETIME_CONFIG =
MAX_TIMESTAMP_LOOKAHEAD = 32
NO_BINARY_CHECK = true
TIME_FORMAT = %s
TIME_PREFIX = ^.+?-.+?-\s+"
TZ = UTC
category = Custom
pulldown_type = true

HTH

Re: Having troubles extracting a time stamp.

lfedak_splunk — Fri, 15 Sep 2017 22:56:08 GMT

Hey @cliffont_merz, if @sshelly solved your problem, remember to "√Accept" an answer to award karma points 🙂

Re: Having troubles extracting a time stamp.

cliffton_merz — Sat, 16 Sep 2017 05:25:32 GMT

Did you do this through the GUI via input data? If so i had forgot to mention that splunk found the timestamp that way. but not when sent from the forwarder. I will also try these options and report back some time over the weekend.

Re: Having troubles extracting a time stamp.

cliffton_merz — Mon, 18 Sep 2017 13:22:50 GMT

This worked, thank you very much. 🙂

topic Re: Having troubles extracting a time stamp. in Getting Data In

Having troubles extracting a time stamp.

REPORT-alienv = av-syslog-hdr, av-syslog-user, av-syslog-srcip, av-syslog-location1, av-syslog-location2, av-syslog-message

REPORT-alienv-loc = av-syslog-location1, av-syslog-location2

FIELDALIAS-signature = action as signature

FIELDALIAS-src = src_ip as src

TRANSFORMS-sev = av-syslog-sev

TRANSFORMS-suppressions = av-win-suppress-detail

Re: Having troubles extracting a time stamp.

Re: Having troubles extracting a time stamp.

Re: Having troubles extracting a time stamp.

Re: Having troubles extracting a time stamp.