...ass the token to the panels am trying to use |eval Time=relative_time(now(),"$time_tok$") which is not working as time token comes with earliest and latest timestamps. So, I've tried strptime to c...
This is driving me nuts because I use strptime all the timeand have many of my own working examples to reference.
I was having a problem doing strptime with a more complex date that wasn't w...
Hello,
I want to use datefunctions in search in order to :
- filter certain hours (for exemple between 12AM and 2 PM)
- filter days of the week (for exemple monday)
how can I extract part o...
I have multiple time fields in my db like Reported Date, Last Modified Date, Responded Date.. If I apply strftime/strptime functions on that it is not working someone plz tell me how to do that.
I need to do the following:
Get a distinct count of serial numbers where a selected date falls within a particular range. Figuring out if a serial number is valid per table row is easy:
eval i...
Hi All,
I need help to figure out a query which give me a report based on time. I have tried out my hands with some query but due to my beginners knowledge of splunk, i have not been able to get i...
We have data fields in the format, for example, 12Jun22 I need to format like 12-06-2022 as shown in the below table:
date
expected format
12Jun22
12-06-2...
I have the following data. Each one has a different date entry.
DATE ACCOUNT_NUMBER SOLUTION NAME ADDRESS
1-1-2015 1 Replaced NAME1 ADDRESS1
1-1-2015 2 R...
...ried to play with various functions to replace 0 with NULL outside the range but couldn't manage to have this apply only outside my time range,. If anybody has an idea on how to solve this issue t...