Andrea Allred does some sleuthing:
Say you have a user come to you and they dropped a table sometime yesterday, but they don’t remember when and now they need it back. You could start the restore process and roll through logs until you see the drop and then restore to the hour before or you could run this super cool query to get the time the table was dropped.
Click through to see when and even which user did it—assuming you don’t have everybody going through a connection pooled account.