I have found a solution on line which i am going to try and use
SELECT
name,
size,
growth,
status,
size * 8 AS size_in_kb,
size * 8 / 1024. AS size_in_mb,
CASE WHEN status & 0x100000 > 0
THEN growth
ELSE NULL END AS growth_in_percent,
CASE WHEN status & 0x100000 = 0
THEN growth * 8 / 1024. END AS growth_in_mb
FROM sysfiles
this only returns the iformation for master trying to change to accept other databases in a loop.