Splunk Search

Help with search to get below scenario

sekhar463
Path Finder

Hi All,

Good day.

need help on search query to get below scenario.

as we have few jobs we need data to calculate sla breach if job was not starting on Actual_start_time and also breach if job is not ended in some threshold of time example 30 seconds.

please help on qyery.

JOB_NAME STATUS START_TIME END_TIME DAYS_OF_WEEK ACTUAL_START_TIME RUNTIME count

PNB-CRDU-USCA-GTRP-EXTRACT-DAILY SUCCESS 2022/11/28 17:00:00 2022/11/28 17:26:26 mo,tu,we,th,fr 17:00 1586 3
PNB-CRDU-USCA-GTRP-EXTRACT-DAILY SUCCESS 2022/11/29 17:00:00 2022/11/29 17:29:07 mo,tu,we,th,fr 17:00 1747 3
PNB-JAWS-TRD-USCA-PORTWARE-EOD-LOAD SUCCESS 2022/11/28 16:30:00 2022/11/28 16:51:01 mo,tu,we,th,fr 16:30 1261 3
Labels (1)
Tags (1)
0 Karma
Get Updates on the Splunk Community!

The Splunk Success Framework: Your Guide to Successful Splunk Implementations

Splunk Lantern is a customer success center that provides advice from Splunk experts on valuable data ...

Splunk Training for All: Meet Aspiring Cybersecurity Analyst, Marc Alicea

Splunk Education believes in the value of training and certification in today’s rapidly-changing data-driven ...

Investigate Security and Threat Detection with VirusTotal and Splunk Integration

As security threats and their complexities surge, security analysts deal with increased challenges and ...