Auditlog Last logins

Hello guys!!

Actually have auditlog plugin writing logins to file audit.log in NEW Format (xml) .
We load the file in database for get last logins of all mysql users.

Is there an easiest way to get last login of each user using only bash script (awk sed etc), python, etc ?

Thanks you all!!

Regards