Log information from a single query? Easy.

Easy to do:

SELECT

CAST(CASE when s.growth=0 THEN (CASE WHEN s.type = 2 THEN 0 ELSE 99 END) ELSE s.is_percent_growth END AS int) AS [GrowthType],

s.name AS [Name],

s.file_id AS [ID],

s.physical_name AS [FileName],

s.size * CONVERT(float,8) AS [Size],

CASE when s.max_size=-1 then -1 else s.max_size * CONVERT(float,8) END AS [MaxSize],

CAST(CASE s.is_percent_growth WHEN 1 THEN s.growth ELSE s.growth*8 END AS float) AS [Growth],

s.is_media_read_only AS [IsReadOnlyMedia],

s.is_read_only AS [IsReadOnly],

CAST(case s.state when 6 then 1 else 0 end AS bit) AS [IsOffline],

s.is_sparse AS [IsSparse]

FROM

sys.master_files AS s

WHERE

(s.name='defa_log')

Results:

GrowthType	Name	ID	FileName	Size	MaxSize	Growth	IsReadOnlyMedia	IsReadOnly	IsOffline	IsSparse
1	defa_log	2	C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\defa_log.ldf	1024	2.147E+09	10	0	0	0	0