Getting Data In

timestamp

lorscardala985
Explorer

i have a problem with the timestamp when i parsing the data, i want the date to start with 28/04/2023 and end with 03/05/2023 but it start with 30/04 then 29/04 and end with 28/04, who can i start the data with 28/04 and not 30/04

Labels (1)
0 Karma

lorscardala985
Explorer

sc.png

 

 

search4.png

this are my sourcetype and the problem with the date

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

This issue doesn't appear to be with the dates per se, it is that the x-axis is sorted lexicographically (alphabetically) - either change your date format to YYYY/MM/DD or change the search so that the results are sorted by ascend time order.

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @lorscardala985 ,

are you speaking of the parsing phase or the search outputs ?

if in the parsing phase, the date is extracted from the log so there isn't a starting or ending date.

If you're speaking of the search output, you can change the sorting order using the sort command:

<your_search>
| sort _time
| table ...

Ciao.

Giuseppe

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

It sounds like the timerange for your search is not correct - how are you setting this?

Also, event usually come back in reverse chronological order (latest first). You can reverse the order with the reverse command or sort command (using _time as the sort variable).

0 Karma
Get Updates on the Splunk Community!

Splunk Enterprise Security 8.x: The Essential Upgrade for Threat Detection, ...

 Prepare to elevate your security operations with the powerful upgrade to Splunk Enterprise Security 8.x! This ...

Get Early Access to AI Playbook Authoring: Apply for the Alpha Private Preview ...

Passionate about security automation? Apply now to our AI Playbook Authoring Alpha private preview ...

Reduce and Transform Your Firewall Data with Splunk Data Management

Managing high-volume firewall data has always been a challenge. Noisy events and verbose traffic logs often ...