# Report showing failed devices **URL:** \ **Category:** Kibana\ **Created:** [January 27, 2020, 3:29pm UTC](https://discuss.elastic.co/t/report-showing-failed-devices/216683 "2020-01-27T15:29:22Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Ian\_Boje](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ian_boje/32/52033_2.png) [@Ian\_Boje](https://discuss.elastic.co/u/Ian_Boje)\ **Post date:** [January 27, 2020, 3:29pm UTC](https://discuss.elastic.co/t/report-showing-failed-devices/216683/1 "2020-01-27T15:29:22Z")
Hi Everyone, I've got some events that look similar to this: ``` Device X failed Device X failed Device X succeeded Device Y failed Device Z succeeded ``` I'd like to create a report that shows a list of devices that failed, but have never succeeded. So, with the example data above, I'd see something like: ` Device:Y count:1` Is that possible? ---
**Author:** ![Ian\_Boje](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ian_boje/32/52033_2.png) [@Ian\_Boje](https://discuss.elastic.co/u/Ian_Boje)\ **Post date:** [January 27, 2020, 6:27pm UTC](https://discuss.elastic.co/t/report-showing-failed-devices/216683/2 "2020-01-27T18:27:39Z")
I didn't google hard enough. After doing more digging, I found some examples of people doing this using scripted fields. I just created two scripted fields, one for fail, one for success. Each get set to '1' when they fail/succeed respectively. Then, I created a report that provides the Sum of each of those fields. Nifty! ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [February 24, 2020, 6:27pm UTC](https://discuss.elastic.co/t/report-showing-failed-devices/216683/3 "2020-02-24T18:27:54Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.