There's a view called sys.master_files that has the size of each file in 8k pages, this has all system and user databases in it.