# Auditlog Last logins

**URL:** <https://forums.percona.com/t/auditlog-last-logins/4624>\
**Category:** Percona Monitoring Plugins\
**Created:** [December 22, 2015, 8:46am UTC](https://forums.percona.com/t/auditlog-last-logins/4624 "2015-12-22T08:46:19Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![santiagopg](https://avatars.discourse-cdn.com/v4/letter/s/0ea827/32.png) [@santiagopg](https://forums.percona.com/u/santiagopg)\
**Post date:** [December 22, 2015, 8:46am UTC](https://forums.percona.com/t/auditlog-last-logins/4624/1 "2015-12-22T08:46:19Z")

</div>

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