Report showing failed devices

[Ian_Boje]

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?

[Ian_Boje]

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!