Looks like you're getting there. Check out these queries! And as always, test the heck out of your work in a development environment! Don't forget databases that might have multiple files!

select * from sys.databases

select * from sys.master_files