SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

It is possible to generate reports from the SharePoint Database with informations like current users, teamsites, websites etc. ? I heard maybe it is possible with the WSS-Logging Database.

Are there any examples? Experience with generating reports like this? Other solutions?

share|improve this question

PowerShell is going to be your best bet. Interacting directly with the database is not encouraged.

share|improve this answer

there are commercial vendors (Avepoint, Idera, Quest, et al) that offer reporting utilities that read the SP databases.. you may want to consider using the Usage & Health Data services to obtain similar information (see - ).

share|improve this answer
found a nice blog post regarding Web Analytics Reporting (as per John Chapman's post above) -… – Supriyo SB Chatterjee Dec 1 '11 at 15:22

Under Site Actions > Site Settings there are some analytics at the site collection and site levels.

For Farm Level analytics, goto Central Admin and under Monitoring goto View Web Analytics.

For more farm-level reports (i.e. structure, sites, etc.) we use SPDocKit.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.