[Building Sakai] when was a user enrolled?

[Adams, David]

I've looked into this in the past and the answer is no, this information is not logged anywhere by default. The fact that realm membership was updated is logged, but not with any information about what was changed. At Virginia Tech, we log all our database traffic and with that data, so it's possible to dig through the logs to find membership changes, but it's obfuscated and there are, obviously, a ton of logs to dig through, even for just a short window of time. I've actually had an item in our local bug tracker to log exact realm/site membership changes, but if you start digging into the code you'll find that it's not as simple as it sounds, alas.

But long story short, if you don't log database query traffic, you won't have this information available.

David Adams
________________________________________
From: sakai-dev-bounces at collab.sakaiproject.org [sakai-dev-bounces at collab.sakaiproject.org] On Behalf Of Algaze, Louis Contractor, eDataTech [ljalgaze at nps.edu]
Sent: Wednesday, February 27, 2013 6:18 PM
To: Sakai Server
Subject: [Building Sakai] when was a user enrolled?

Hello,

Does anyone know if transactional data for realms/membership is stored anywhere?

I'm trying to find out when a specific user was enrolled/dis-enrolled in a specific site, and by whom if available.   This would need to include their status (active/inactive).

I can view the Sakai_Events but that just tells me who made any modifications to the site membership/realm (site.upd.site.mbrshp) but not which user was enrolled/dis-enrolled.

Thank you for any information you might be able to provide.

Louis Algaze