Are you looking too deep into a simple problem?

Would this not provide the answer you need?

select name, size from sys.master_files;