You could also modify the previous query to use sys.master_files. That will prevent you from having to loop through each database and you may not need a temp table either.