After reading several posts on the internet for discovering database restoration history, I realized that most were way over complicating what you can do in SQL 20008R2 and up.
This is the easiest method for me:
use msdb
select * from restorehistory
And that is pretty much it.
However, I do have one server that is making me scratch my head. The restorehistory table is empty, but the logs clearly show that I had several restores in the last 3 months. Hmmm.
UPDATE:
OK I feel rather stupid about this. Of course the restore history is empty, I am cleaning it up with part of my maintenance plan!