Splunk Search

SPL command to copy paste rows in lookup with increment values

gowtham495
Path Finder

i have lookup like following :

ID jobname start_time end_time frequency
1 abc 0:00 21:00 60
2 def 3:00 4:00 10
.....
.
.
.

i need to populate the lookup in such a way that i should have my 1st row repeated 21 times (i.e no of times the job gets repeated between the start time and end time, having 60 minutes of frequency)
similarly, def row should repeat for 10 times (i.e. 3:10, 3:20, 3:30,....4:00)
is there any SPL command to populate the lookup like this ?

Thanks.

0 Karma

niketn
Legend

@gowtham495, what is the current query you are using? Please elaborate your requirement. Is the current output 2 rows from where you need to generate 21 rows for first and 10 rows for second?

What is the expectation/format of the final output to be uploaded to the lookup file?

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma
Get Updates on the Splunk Community!

Aligning Observability Costs with Business Value: Practical Strategies

 Join us for an engaging Tech Talk on Aligning Observability Costs with Business Value: Practical ...

Mastering Data Pipelines: Unlocking Value with Splunk

 In today's AI-driven world, organizations must balance the challenges of managing the explosion of data with ...

Splunk Up Your Game: Why It's Time to Embrace Python 3.9+ and OpenSSL 3.0

Did you know that for Splunk Enterprise 9.4, Python 3.9 is the default interpreter? This shift is not just a ...