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

[Leon Kolchinsky]

Thank you John and David,

This Oracle query that John uses, did it for me ;) !!!!

Best Regards,
Leon Kolchinsky



On Tue, Apr 19, 2011 at 22:16, John Leasia <jleasia at umich.edu> wrote:

>  Leon,
> 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,
> se.ref
> 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
>
> John
>
>
> 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 listproduction at collab.sakaiproject.orghttp://collab.sakaiproject.org/mailman/listinfo/production
>
> TO UNSUBSCRIBE: send email to production-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
>
>
>
> _______________________________________________
> production mailing list
> production at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/production
>
> TO UNSUBSCRIBE: send email to
> production-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/20110420/505d9c04/attachment.html