Here's a couple of queries, they only apply to SQL Server 2005+ that allow you to track what log was applied and when; and which was the last log applied to a database.
-- list all the logs applied to a database
select
restore_date,
(select top 1 physical_device_name from msdb..backupmediafamily mf where mf.media_set_id = bs.media_set_id) as [File],
last_lsn
from msdb..restorehistory rh with(nolock)
join msdb..backupset bs with(nolock)
on bs.backup_set_id = rh.backup_set_id
where rh.destination_database_name = 'poker'
order by restore_date desc
-- this one just grabs the last log applied, same as above but with rows restricted
select top 1
restore_date,
(select top 1 physical_device_name from msdb..backupmediafamily mf where mf.media_set_id = bs.media_set_id) as [File],
last_lsn
from msdb..restorehistory rh with(nolock)
join msdb..backupset bs with(nolock)
on bs.backup_set_id = rh.backup_set_id
where rh.destination_database_name = 'poker'
order by restore_date desc