in reply to Hashref for specific values

Per previous reply, it's not clear what you want to put into @logged_events. If all you want is the results from the fetchrow_hashref() calls, then what you've got will work. I'd suggest clarity over fitting-it-on-one-line, though. And really, there's no point in using $_ here.
my @logged_events;

while (my $record = $sth_le->fetchrow_hashref())
{
    push @logged_events, $record;
}

seems cleaner to me. If you want specific things from the hash ref, then you can do, e.g.:

while (my $record = $sth_le->fetchrow_hashref())
{
    push @logged_events, $record->{SOME_KEY};
}