Interested to know a query to see all the LOG file info from the current DB ? Easy to do, SQL Server

Easy to do, just execute the following query:

SELECT

s.name AS [Name],

CAST(FILEPROPERTY(s.name, 'SpaceUsed') AS float)* CONVERT(float,8) AS [UsedSpace],

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.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],

s.file_id AS [ID],

'Server[@Name=' + quotename(CAST(

        serverproperty(N'Servername')

       AS sysname),'''') + ']' + '/Database[@Name=' + quotename(db_name(),'''') + ']' + '/LogFile[@Name=' + quotename(s.name,'''') + ']' AS [Urn],

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.type = 1 and s.database_id = db_id())

ORDER BY

[Name] ASC

Results: