Query to find dbs that are log shipped

I need to find out all the dbs that are currently in readonly/standby state
on my standby servers. These databases are log shipped with standby option
ThanksCheck out the DATABASEPROPERTY() and DATABASEPROPERTYEX() functions.
--
Tibor Karaszi
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23jgPwn8oDHA.424@.TK2MSFTNGP10.phx.gbl...
> I need to find out all the dbs that are currently in readonly/standby
state
> on my standby servers. These databases are log shipped with standby option
> Thanks
>