BuddyPress.org

As of BuddyPress 2.0, last_activity is no longer stored in usermeta.
However, it is mirrored there for backward compatibility.
Instead, refer to the _bp_activity table.

My first reply included a link to code for insuring that all members have a ‘last_activity’ timestamp.
Did you follow the directions and run the code?