List All Login Info
View login tracking for all accounts:
select li.account_id, a.username, li.last_login, li.failed_logins, li.locked, li.online, li.last_ip from ores.login_info li join ores.accounts a on a.id = li.account_id and a.valid_to = '9999-12-31 23:59:59'::timestamptz order by li.last_login desc nulls last;