[Deploying Sakai] How to find out who deleted specific site?

John Leasia jleasia at umich.edu
Tue Apr 19 05:16:06 PDT 2011

I use this (on Oracle db) to find the user account that deleted a site 
when I know the site id, and usually try to restrict the date because 
searching through the event and session tables is (for us) pretty slow 
due to their size.  If you don't know the site_id, then you could leave 
the 'and ref=...' bit out and you'll find all sites deleted, and use 
some sleuthing to figure out which is the one you are interested in.

select  ss.session_user, session_ip, smap.eid,  se.event_date, se.event, 
from sakai_session ss,  sakai_event se, sakai_user_id_map smap
where ss.session_id = se.session_id
and ss.session_user=smap.user_id
and event = 'site.del'
and ref = '/site/' || '<put siteid here>'
and se.event_date > sysdate - 2


David Horwitz wrote:
> Hi Leon,
> Deleting a site will leave a site.del event in the SAKAI_EVENT table - 
> it will be referenced by the site id though not the name.
> Regards
> David
> On 04/19/2011 07:15 AM, Leon Kolchinsky wrote:
>> Hello,
>> Some of our users deleted one of the sites and I want to find out who 
>> did it and when ;)
>> Is there a way to find out who and when deleted a site (I know the 
>> site's name)?
>> Any specific log entries in the DB?
>> Cheers,
>> Leon Kolchinsky
>> _______________________________________________
>> production mailing list
>> production at collab.sakaiproject.org
>> http://collab.sakaiproject.org/mailman/listinfo/production
>> TO UNSUBSCRIBE: send email toproduction-unsubscribe at collab.sakaiproject.org  with a subject of "unsubscribe"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20110419/b902dc96/attachment.html 

More information about the production mailing list