Splunk Search

SPL command to copy paste rows in lookup with increment values

Path Finder

i have lookup like following :

ID jobname starttime endtime 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

SplunkTrust
SplunkTrust

@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