how to create reporting inform my the 'username' and how many attempt to failure loging and the destination IP address
You need to have a report and include 'count username' field. Sort the report in descending order on that field and you should have what you need.
Hope this helps.
Retrieving data ...