Splunk Search

SPL command to copy paste rows in lookup with increment values

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 ?


0 Karma


@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!

Dashboard Studio Challenge - Learn New Tricks, Showcase Your Skills, and Win Prizes!

Reimagine what you can do with your dashboards. Dashboard Studio is Splunk’s newest dashboard builder to ...

Introducing Edge Processor: Next Gen Data Transformation

We get it - not only can it take a lot of time, money and resources to get data into Splunk, but it also takes ...

Take the 2021 Splunk Career Survey for $50 in Amazon Cash

Help us learn about how Splunk has impacted your career by taking the 2021 Splunk Career Survey. Last year’s ...