Hi Splunk Community, I’m looking for guidance on implementing an accurate Mean Time to Detect (MTTD) calculation for our SOC dashboard using Splunk Enterprise Security. Currently, we are using the index=notable to retrieve notable events generated by correlation searches. My objective is to calculate: MTTD = Average (Detection Timestamp - First Occurrence Timestamp) However, I’m facing a few challenges: The orig_time field in the notable index is returning the same value as _time.
... View more
is above query will give the list of all transmitted in 2 weeks .....need only those which are not triggering in last 7 days but triggering in 15 days....
... View more
Thanks so much for your help and input...not getting any result may be the case there is no such server(host)....thanks again for your help and time.
... View more
Thanks for your input. I mean I have a csv file which has the list of servers ....from that inputlookup table I need to get the list of servers sending data in last 14 days but not in 7 days..could you please help me in that.. Thanks
... View more
Hi Team,
Could you help me with the complete splunk query for list of servers which are sending data in last 14 days from the lookup and not sending in last 7 days
if we write....
| eval day=if(_time<relative_time(now(),"-7d@d"),"sentdatalastweek","didnotsenddatainthelast7days")
what does that mean?
Regards
... View more