Aggregate data view but with time of last entry
I want to list the number of times that users have failed to log into my web server in the past 24 hours, and the reason why. I can that pretty easily by parsing the message and counting on the usernames and error codes. However, I also want to the aggregate output to report the last time the user failed to login. I can see the "last" function but I can't work out if I can use it for this. Any help, please?
Please sign in to leave a comment.
Comments
2 comments