Reporting...

I have a mobile app that uses merge replication. I need to provide
management and easy to access (and read) report showing when mobile users
updated last. As I am using SQLCE, I have to use anon subs, but... each
publication has only one PDA reading it.
I need to know where to look in the database for publication information.
Right now I manually open Enterprise Manager, and on the server open
Replication Monitor > Publishers > SQLSERVER... then have to export each
publiction indivdually.
I know this is meta-data somewhere in the server, just need to be pointed in
the right direction so I can build a report to extract it for management.
Zac
I found what I needed. Still need to fine tune it. But I have the info I
need.
"Zac Maclean" <user@.some.com> wrote in message
news:esUM3fZHFHA.904@.tk2msftngp13.phx.gbl...
>I have a mobile app that uses merge replication. I need to provide
>management and easy to access (and read) report showing when mobile users
>updated last. As I am using SQLCE, I have to use anon subs, but... each
>publication has only one PDA reading it.
> I need to know where to look in the database for publication information.
> Right now I manually open Enterprise Manager, and on the server open
> Replication Monitor > Publishers > SQLSERVER... then have to export each
> publiction indivdually.
> I know this is meta-data somewhere in the server, just need to be pointed
> in the right direction so I can build a report to extract it for
> management.
> Zac
>