David Fowler checks the calendar:
Your boss walks up to you one morning and says, “Hey, I wanna list of all of our databases and when they were last accessed”.
If you’ve got some sort of auditing switched on or a trace or xevent catching this sort of info you might be ok, but I’m betting you don’t have any of that. That’s cool, it’s not something that I tend to monitor as standard either.
But if you’re not monitoring it, is there any way that you can get at that info?
Read on for one way to estimate it. Though I believe automated jobs would skew that result if the underlying question is, “When did a human last view that database?”