Zabbix audit session logins

Recently needed to query the zabbix database running under mysql to obtain the last session logins per user. Zabbix stores all times since epoch  (Jan 1, 1970 00:00 GMT), so it will be necessary to convert these.    This page has useful formatting when using FROM_UNIXTIME example

select users.alias,users.name, FROM_UNIXTIME(lastaccess ,"%Y-%m-%d %T") AS `lastaccess` from sessions,users where users.userid=sessions.userid and lastaccess > (UNIX_TIMESTAMP(NOW()) -282800) order by lastaccess desc

output: