Login logs

tiekubd · September 4, 2020, 1:43am

How/where can I view:

Login logs
Currently logged in users
Users logged-in in the last X minutes
Successful login attempts
Failed login attempts

sandra · September 4, 2020, 3:47am

Hi Tieku,

The logs can be found in System Admin > View Logs. If you’d like to query the logs for specific things, like failed logins or currently logged in, you’d likely need to write a query.

ross · September 4, 2020, 4:39am

Just to add to this, there are some basics filter options in View Logs, but Sandra is right, that your questions will mostly require queries. Thanks!

meierrom · September 4, 2020, 8:23am

I wonder how I could query info on “currently logged” in. Any hints?

Ashton · September 5, 2020, 11:37am

I wonder how I could query info on "currently logged" in. Any hints?

Just whipped this up now, but it takes the Session Duration and finds all users who've logged in within that time, seeing as the system doesn't appear to log when users are logged out this may be the closest you could get.

SELECT *, gibbonsetting.value
FROM `gibbonLog` 
JOIN gibbonsetting on (gibbonsetting.gibbonsettingID=00145)
WHERE title="Login - Success" AND TIMESTAMPDIFF(SECOND, timestamp, NOW()) <= gibbonsetting.value`