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!

Security Professional: Sharpen Your Defenses with These .conf25 Sessions

Sooooooooooo, guess what. .conf25 is almost here, and if you're on the Security Learning Path, this is your ...

First Steps with Splunk SOAR

Our first step was to gather a list of the playbooks we wanted and to sort them by priority.  Once this list ...

How To Build a Self-Service Observability Practice with Splunk Observability Cloud

If you’ve read our previous post on self-service observability, you already know what it is and why it ...