Variant Report for Failed Logins

Variant Report for Failed Logins

Hi there,
I am trying to get a failed login report set up with a slight variant to it. I would like it to show a user name, and the total count of their failed login attempts during that period, and if possible, have that broken down into the categories why (like bad password or account expired), along with the total count for those. This way I can generate a condensed list to track reasons from a high level, and then drill down where needed.

Thanks in advance for any help/advice on this.

Andy