Splunk Search

How to format table for resolved record after comparing two timestamp

ninadbhaskarwar
Path Finder

Hi Friends,

My data set as below

ID    Date
1      01/01/2010
1      01/02/2010
2      01/01/2010
3      01/01/2010
3      01/02/2010
1      01/03/2010
4      01/02/2010
4      01/03/2010

Looking for the table with the data

Date           Count    Fixed
01/01/2010     3        1
01/02/2010     3        1
01/03/2010     2        0  

Regards.

0 Karma

Vijeta
Influencer

what is column Fixed here?

0 Karma

ninadbhaskarwar
Path Finder

@vijeta - When record get closed earlier date then it will not be visible on next date so If the id is not available in the next date then that record has been considered to be fixed.

0 Karma

niketn
Legend

@ninadbhaskarwar what is the criteria for identifying fixed?

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma

ninadbhaskarwar
Path Finder

If the id is not available in the next date then that record has been fixed.

0 Karma
Get Updates on the Splunk Community!

.conf24 | Day 0

Hello Splunk Community! My name is Chris, and I'm based in Canberra, Australia's capital, and I travelled for ...

Enhance Security Visibility with Splunk Enterprise Security 7.1 through Threat ...

(view in My Videos)Struggling with alert fatigue, lack of context, and prioritization around security ...

Troubleshooting the OpenTelemetry Collector

  In this tech talk, you’ll learn how to troubleshoot the OpenTelemetry collector - from checking the ...