Log space usage for the current database

SELECT DB_NAME(lsu.database_id) AS [Database Name]
	,db.recovery_model_desc AS [Recovery Model]
	,CAST(lsu.total_log_size_in_bytes / 1048576.0 AS DECIMAL(10, 2)) AS [Total Log Space (MB)]
	,CAST(lsu.used_log_space_in_bytes / 1048576.0 AS DECIMAL(10, 2)) AS [Used Log Space (MB)]
	,CAST(lsu.used_log_space_in_percent AS DECIMAL(10, 2)) AS [Used Log Space %]
	,CAST(lsu.log_space_in_bytes_since_last_backup / 1048576.0 AS DECIMAL(10, 2)) AS [Used Log Space Since Last Backup (MB)]
	,db.log_reuse_wait_desc
FROM sys.dm_db_log_space_usage AS lsu WITH (NOLOCK)
INNER JOIN sys.databases AS db WITH (NOLOCK) ON lsu.database_id = db.database_id
OPTION (RECOMPILE);

dm_db_log_space_usage, databases