Good day All!
i have created a lookup data | inputlookup Autosys.csv and i have fileds KB,REGION AND JOB_NAME.
i have splunk search which i have some job data .
how can ingest other fields in t...
See more...
Good day All!
i have created a lookup data | inputlookup Autosys.csv and i have fileds KB,REGION AND JOB_NAME.
i have splunk search which i have some job data .
how can ingest other fields in the lookup using JOB_NAME as common fileds splunk events
below is the search which i want to add lookup data
index=index_name sourcetype=source_name
| eval Actualstarttime=strftime(strptime(NEXT_START,"%Y/%m/%d %H:%M:%S"),"%H:%M")
| eval Job_start_by=strftime(strptime(LAST_START,"%Y/%m/%d %H:%M:%S"),"%H:%M")
| eval START_SLA=if(Job_start_by <= Actualstarttime,"Started On Time","Started Late")
| eval END_SLA=if(RUNTIME <= AVG_RUN_TIME,"END ONTIME","END SLA BREACH")
| search NEXT_START!=NULL
| table JOB_NAME,JOB_GROUP,TIMEZONE,STATUS,Currenttime,STATUS_TIME,LAST_START,LAST_END,NEXT_START,DAYS_OF_WEEK,EXCLUDE_CALENDAR,RUNTIME,Actualstarttime,Job_start_by,START_SLA,AVG_RUN_TIME,END_SLA