Hi--Thanks for your article. Can you provide a couple of user queries for wss v2? 1) Return the same info as for site hierarchy but include all the admins for each site; 2) email address to which access requests go by site. Many thanks!
this information has proved to be very useful! i'd like to see the second part of this...
I have demonstrated how easy it to analyze a SharePoint Portal solution. In the second part of the article, I will try to write queries on Users, User Profiles, Subscriber Lists, Site Groups, Cross Site Groups etc.
The information provided through the article is excellent,but i knew that you direct queries to SBS is not recommended at all,because it breaks the SBS object model... if you want to query from SBS you have to use SBS web services... this is the information i got from MS Support.... then please update or hint this info in this article.
Very true! So far, you can "read" the databases, but no "writes" are allowed as this could void your support from MS. You have to use the SharePoint Object model instead to make any updates/deletes/inserts.
Additionally, customers must not make support-guided changes outside a support incident or provide such changes to other customers for use outside a support incident. In addition to the items previously mentioned, customers are strongly advised against direct access in a read-only manner to these databases unless Microsoft protocol documentation is followed exactly. Accessing these databases programmatically or manually could cause unexpected locking within Microsoft SQL Server that can result in overall performance problems. To view the SharePoint Products and Technologies protocol documentation, visit the following Microsoft Web site:
Last Visit: 31-Dec-99 19:00 Last Update: 24-Jan-15 22:04