I have come accross below link while checking options to find top painful mirroring enabled databases.
Looks like there is no single query/DMV to get this info.
back to this link.
Excellect collection of key notes for almost all key SQL topics. Great work Jose Barreto.
Good source for Senior DBAs to quickly refresh the topics periodically.