You can do it for example with small shell script and crontab.
1) Create script called log-script.sh to MobileID server that uses default database middb. Script will select authentication messages that are higher than the current time minus 1 hour
mysql -u $USER -p$PASSWD -e 'select * from middb.Access WHERE Time >= now() - interval 1 hour;' >> $LOGFILE
2) Change variables USER,PASSWD and LOGFILE.
3) Choose user that has write access to log file and create cron job
# crontab -e
0 * * * * /path/to/log-script.sh
4) Make sure that script have executable permissions
# chmod +x /path/to/log-script.sh
Now script is executed every hour. You can list your cron jobs with command
# crontab -l
Sep 04 '12 at 12:03