SQL Script to check space used by all log files

Following script helps us to get

1. Current total Log File size occupied by every database
2. How much space is free inside a log file

-- ***********************************************************************************/
-- Description  :    Script to check space used by all log files  
--                        space used for all log files
-- Compatibility  :     7.0+
-- This Script should be executed in master
-- ***********************************************************************************/
use master
go
Dbcc sqlperf(logspace)
go