I have occasion to look at large servers, and as part of that process I need to look at all the files to see if they're ok, I'm particularly interested in the size of the log files (we might need to shrink them)
This query will quickly show you where they all are
select db.name , a.filename,a.size, a.*
from sysdatabases db
join sysaltfiles a on a.dbid = db.dbid