Splunk Search

Append do not work anymore

New Member

Hello

I did a code using append it was working perfectly. I didn't use my code for a week and now it is not working anymore.
Have you ever seen that before ?

my code:
index="my-index"

|append [search (type="repair_event" test_station="test1" )
OR (type="status_event" descriptor_name="test1" )
| stats distinct_count(serial) as r, distinct_count(number) as q by work_order | eval percent_err= round((q/r)*100,100) | eval percent_ok1=(100.00-percent_err)
]

|append [search (type="repair_event" test_station="test2" ) OR (type="status_event" descriptor_name="test2" )
| stats distinct_count(serial) as r, distinct_count(number) as q by work_order | eval percent_err= round((q/r)*100,100) | eval percent_ok4=(100.00-percent_err)
]

| stats first(percent_ok1),first(percent_ok4) by work_order

Thanks for your help

Tags (2)
0 Karma

Communicator

Are you in the same app as you were previously when it worked?

0 Karma

SplunkTrust
SplunkTrust

What do you mean by "not working"? What results are you getting now compared to what you were getting a week ago?

---
If this reply helps you, an upvote would be appreciated.
0 Karma
State of Splunk Careers

Access the Splunk Careers Report to see real data that shows how Splunk mastery increases your value and job satisfaction.

Find out what your skills are worth!