Get latest events by role