CREATE TABLE ##T (db               NVARCHAR(128), 
                  RecoveryUnitId   INT, 
                  FileId           SMALLINT, 
                  FileSize         NUMERIC(38, 0), 
                  StartOffset      NUMERIC(38, 0), 
                  FSeqNo           NUMERIC(38, 0), 
                  Status           Bit,
                  Parity           SMALLINT, 
                  CreateLSN        NUMERIC(38, 0));

DECLARE @CMD NVARCHAR(max) = N''

SELECT @CMD = @CMD + N'
INSERT INTO ##T (RecoveryUnitId, FileId, FileSize, StartOffset, FSeqNo, Status, Parity, CreateLSN)
EXEC (''USE [' + name + '];DBCC LOGINFO;'')
EXEC (''USE [' + name + '];UPDATE ##T SET db = DB_NAME() WHERE db IS NULL;'')'
FROM sys.databases 
WHERE source_database_id IS NULL
AND state = 0;

EXEC (@CMD);

SELECT db, COUNT(*) AS NB_VLF
FROM   ##T
GROUP  BY db
ORDER  BY 2 DESC;

DROP TABLE ##T ;