Last VLF status of the current database

SELECT TOP (1) DB_NAME(li.database_id) AS [Database Name]
	,li.[file_id]
	,li.vlf_size_mb
	,li.vlf_sequence_number
	,li.vlf_active
	,li.vlf_status
FROM sys.dm_db_log_info(DB_ID()) AS li
ORDER BY vlf_sequence_number DESC
OPTION (RECOMPILE);