Show Django Admin Log entries
select u.username, u.first_name, u.last_name, l.action_time, c.name, c.app_label,
l.object_id as "Object Modified", l.object_repr, l.action_flag, l.change_message
from (auth_user u inner join django_admin_log l on u.id = l.user_id )
inner join django_content_type c on c.id = l.content_type_id
where l.object_id = '9' /* filter by object id if desired */
and l.action_time > to_date('2010-10-04 01:00','YYYY-MM-DD HH:MI') /* filter by date range */
order by l.action_time;
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment