This is great and so close to what I'm looking for. However we do have several databases that consist of several ndf files, this only shows me the main file and it's location. Is there a way to modify this so it can show me each file? I also have been asked to include if the database is mirrored or not. I have been trying to mod it on my end so far, my skills are not there.
----Just figured this out, by changing the where filter to type. Sorry, can't seem to delete this post.