User Access Records

General
1

Greetings again, Gibbon!

I am wondering if there is a place in Gibbon where I can check user activity on the platform. I know how to look at active sessions (in the System Admin), but I have not been able to locate a report that shows when and from where users have accessed the system in the past.

I assumed this had to exist in records somewhere, but I wasn’t sure and didn’t know where to look.

Thank you for the guidance!
Kevin

2

Hi Kevin, there is a system log that includes timestamps for user logins, which can be viewed in System Admin > View Log. The best way to get the information you’re looking for is likely with Query Builder to query the gibbonLog table. Here’s an example of getting user login stats for a 90 day window:

SELECT
    surname,
    preferredName,
    username,
    gibbonRole.name AS role,
    COUNT(*) as loginCount,
    timestamp as recentActivity
FROM 
    gibbonLog
    JOIN gibbonPerson ON (gibbonLog.gibbonPersonID=gibbonPerson.gibbonPersonID)
    JOIN gibbonRole ON (gibbonPerson.gibbonRoleIDPrimary=gibbonRole.gibbonRoleID)
WHERE
    gibbonLog.title LIKE '%Login - Success'
    AND timestamp >= DATE_SUB(CURRENT_DATE, INTERVAL 90 DAY)
GROUP BY gibbonPerson.gibbonPersonID
ORDER BY timestamp;
3

The “View Logs” option was the one I was looking for, Sandra, so that solves most of my problem. I will absolutely use your query, though–that’s a nice bonus.

Have a great day!
Kevin

1 Like