log shipping status

We have set up log shipping in standby mode so users can run some reports.
Every once in while, the restores long runner and our users would like to
know how much more time before its done.
Is there any query they could run to see what files its restoring or the
last file it has restored so they can get a feel of what Tlog file is being
processed.
It may not be perfect, but its a lot better if they know that the last Tlog
file restored or the current file its restoring is just 10 mins ago vs 10
hrs ago.
Thanks
Hassan
Take a look at DBCC LOGINFO(dbid) command
"Hassan" <hassan@.test.com> wrote in message
news:OIv5slyKIHA.3848@.TK2MSFTNGP05.phx.gbl...
> We have set up log shipping in standby mode so users can run some reports.
> Every once in while, the restores long runner and our users would like to
> know how much more time before its done.
> Is there any query they could run to see what files its restoring or the
> last file it has restored so they can get a feel of what Tlog file is
> being processed.
> It may not be perfect, but its a lot better if they know that the last
> Tlog file restored or the current file its restoring is just 10 mins ago
> vs 10 hrs ago.
> Thanks
>