Expanding on Steve's script a little, here is one that I did:

SELECT T1.Name AS DatabaseName

,ISNULL(t2.database_name, 'No Backup Taken') AS LogBackupAvail

,T1.recovery_model_desc

,'Log' AS BackupType

,ISNULL(CONVERT(VARCHAR(23), CONVERT(DATETIME, Max(T2.backup_finish_date), 131))

, CASE WHEN T1.recovery_model_desc = 'Simple'

THEN 'N/A'

ELSE 'Backup Not Taken'

END

) AS LastBackUpTaken

FROM sys.databases T1

LEFT OUTER JOIN msdb.dbo.backupset T2

ON t1.name = t2.database_name

AND t2.type = 'L'

GROUP BY T1.Name,T2.database_name,T1.recovery_model_desc