(imported comment written by kasadis91)
That’s much closer. I’d tried Multiplicity but hadn’t figured out how to combine the event id, description, and record count to the results. I’ve added the event ID to your query, changed the filter to all error events within the last day, and here’s what I have now:
Q:(multiplicity of it, it) of unique values of ((concatenation of substrings separated by “%0d%0a” of description of it, (event id of it mod 2147483648 mod 1073741824)) as string) of (records of application event log) whose ((event type of it = error event log event type) and (time generated of it > (now - 1*day)))
A: 1, ( The HDX MediaStream for Flash Service is not available. Server-side Flash rendering will be used if available. , 45 )
A: 3, ( An unexpected error has occured in “QuickBooks”:Returning NULL QBWinInstance Handle, 4 )
That should do it. Thanks for your help and I hope this helps someone else.