Microsoft Content Management Server - Query to find CMS page count?

Author

Query to find CMS page count?

Andy Fitch

2004-07-28, 6:10 pm

Hey all,
Does anyone know of a sql query that can be used to
determine the number of postings in a CMS system?
Thanks much
Andy

Stefan [MSFT]

2004-07-28, 6:10 pm

Hi Andy,

direct access to the Database breaks the Microsoft Support boundaries.
Rather than doing this you should enumerate the repository using Publishing
API.

Thanks,
Stefan.

--
This posting is provided "AS IS" with no warranties, and confers no rights.

MCMS FAQ:
http://download.microsoft.com/downl...6a/MCMS+2002+-+(complete)+FAQ.htm
MCMS Blog: http://blogs.msdn.com/stefan_gossner/category/4983.aspx
MCMS Sample Code:
http://www.gotdotnet.com/community/...t+S
erver
MCMS Whitepapers and other docs:
http://blogs.msdn.com/stefan_gossne...2/07/41859.aspx
--------------------------------

"Andy Fitch" <anonymous@discussions.microsoft.com> wrote in message
news:4e8d01c473e6$8bc9d870$a601280a@phx.gbl...
> Hey all,
> Does anyone know of a sql query that can be used to
> determine the number of postings in a CMS system?
> Thanks much
> Andy